Forum Discussion

hwan's avatar
hwan
Frequent Visitor
10 years ago
Solved

Line and stacked column chart - Y-axis

Hello,   I am trying to do a line and stacked column chart to compare revenue and cost. My axis is month. I am thinking to use the line for revenue, stacked column for costA and costB(costA+costB =...
  • Sean's avatar
    Sean
    10 years ago

    hwan You can do 2 things...

     

    1) Enter start and end values to match the primary axis

    OR

    2) Turn off the secondary axis

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Can you explain this a little more? There is only one Y-Axis for both the line and column series. Is the issue that the costs are so high as compared to revenue that you effectively see a flat line for revenue? Can you post an image and point out the issue? What would be your preferred outcome?

  • hwan's avatar
    hwan
    Frequent Visitor
    10 years ago

    Sure.

     

    1. this one below has only one Y-axis and the proportion is what I want.

     

     

    2. This one below has 2 Y-axises and the image is misleading. You can see that in July the total costs is abut $3M vs. $800k revenue while the chart might deliver a quite different impression at first look.

     

     

    Hope this makes sense,

    Hui

    • Sean's avatar
      Sean
      Icon for Community Champion rankCommunity Champion
      10 years ago

      hwan You can do 2 things...

       

      1) Enter start and end values to match the primary axis

      OR

      2) Turn off the secondary axis

       

       

      • hwan's avatar
        hwan
        Frequent Visitor
        10 years ago

        Thanks Sean! Didn't know there is an option to turn off the secondary axis.