Forum Discussion
Excel charts: revenue and margins over a time period
Hi all,
I want a chart showing the development in revenue and margins over a period of three yrs. I want the revenue to be marked on the left hand x axis and margins to be marked on the right hand x axis (secondary axis). I can't quite get it to look the way I want. See the attached picture. What I want is for the margins (currently shown as lines across the three companies) to show as lines across each company over the time period. So basically one line across company A, one line across company B and one line across company C.
Appreciate any help!
Best regards,
Kris
1 Reply
I think you need to declare the charts with Switch Row/Column to plot against year. I am also not convinced that there is much to be gained by stacking the column and line presentation within a single chart (see below). Two adjacent charts may well be clearer.
