Axis change for stacked and clustered columns

C

Calgarychris

Hi,

I have 4 expense categories that I am comparing prior to budget to actuals
(ie 3 stacked columns). In the same chart, I would like to have the same
setup, but with YTD amounts. I can get it to work, but the problem is that
the YTD values are obviously much larger and I need to get them onto the
second axis - can anyone provide some guidance?!

Mar Prior Mar Budget Mar Actual YTD Prior YTD Budget
YTD Actual
Sal 10 12 15 30
36 45
Occu 5 6 7 15
18 21
Selling 2 2 2 8
6 7
G&A 3 4 4 5
7 9









Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top