If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Grouped stacked bar chart with % on 2nd axis?
I'm trying to create a chart that is grouped and stacked - with a % variance
line on a second y axis. I am trying to show performance against budget in different groups, with budget used and budget remaining in one stack, actual money used in the second stack, and then the 2 stacks grouped for different business units. On top of that I want a % variance line on the second Y axis. Any thoughts? Thanks... |
#2
|
|||
|
|||
Grouped stacked bar chart with % on 2nd axis?
Jonathan -
You can stagger the data like this: Budget Used Budget Remaining Money Used % Variance Company A 150 75 35 15% Company B 200 55 55 20% The labels won't all line up perfectly this way, but Bernard Liengme shows how to use a dummy series to provide nice category labels: http://www.stfx.ca/people/bliengme/e...e_column_chart - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Jonathan wrote: I'm trying to create a chart that is grouped and stacked - with a % variance line on a second y axis. I am trying to show performance against budget in different groups, with budget used and budget remaining in one stack, actual money used in the second stack, and then the 2 stacks grouped for different business units. On top of that I want a % variance line on the second Y axis. Any thoughts? Thanks... |
Thread Tools | |
Display Modes | |
|
|