I'm making a combination chart showing the growth of a value week by week as columns, while for the line I want to illustrate the percentage change week by week. The problem is that the column values are quite high while, the percentage changes are sub 10% resulting in my columns displaying nicely while the percentage line just lays at flat at the bottom of the chart.

Is there any way to shift the proportion of the line so that it is possible to see it rise and fall with the percentage growth/fall each week?

1 Answer 1


Your best bet is probably to plot one series on one vertical axis and the other series on the other vertical axis, then the scale and range of each is independent of the other:

WA101001 example

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.