Forum Discussion
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 = total cost). Unfortuntely in some cases the costs can be much higher than revenue. My question is how to make sure the scales of Y-axis for the line and the column are the same so the visualization represents the cost/revenue comparison correctly?
Thanks,
Hui
6 Replies
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?
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
