Excel 2007: Creating secondary axis on chart 2

[bnsSteve]

Hello,

I would like to create a secondary axis for only 1 of the horizontal groups in my excel bar chart.

Ex: Y-axis is dollar amount; X-axis I have 5 different columns, 1) Total $amt, 2)avg $amt, 3)max $, 4)min $, 5)$std dev.

Each x-axis column is comparing values for A and B. My problem is that the Total $amt is a lot larger then the other columns so I would like to make this comparison bw A&B on the secondary axis.

hope this is possible, please let me know if further clarification is needed.

Thanks!

 

[BlueHorizon]

Hello bnsSteve,

You can create a secondary axis (usually a line chart over a column chart) by selecting all data (including the values that you want represented on the secondary axis) and creating the column chart in 2D only. Right click the series representing the secondary axis values and create the axis. Then with the new axis selected, change the chart type to a line.

Hope this helps,


Best,
Blue Horizon

 

[bnsSteve]

Thanks Blue Horizon.

Yeah I tried adding the second y-axis using the fomat selection - series option to add the second y-axis but it selects all of the A values. I would like to just select the first group (Total amount for A vs B) and plot that on the second axis, while leaving the rest of the groups on the primary axis.
How my bar chart is set up, is that there are basically 5 different bar charts side by side all using the same y-axis ($). The x-axis is just A&B for each section. So i would like to put the first section on to the secondary axis, but i think the way its set up its probably not posible..

 

[SkipVought]

hi,

I would like to just select the first group (Total amount for A vs B) and plot that on the second axis

If you currently have TWO series (A & B), then you need to add an additional TWO series, for the TOTALS.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bnsSteve]

Thanks Skip I got it