Display Right axis on stacked bar chart (EXCEL XP)

Topic

New Reply

Pls. refer to the attached example. Is there any way both a left and right axis / scale [i.e., duplicate the left axis scale on the right side]. The chart will be embedded in a powerpoint slide and think axis / scale information on both the left and right make the chart more realistic and useful. But I have can’t seem to get a right scale/axis to display. Is this possible in EXCEL when using a stacked bar chart? THANKS.

Reply | Quote

Replies

One way:

Enter some bogus numbers in the empty column to the right of your data and drag that range onto your chart. Now select that series and hit control-1 and change the axis to secondary axis and adjust the scale to match the other axis. Lastly, remove the numbers from the column. See attached.

Reply | Quote

Thanks. This works perfectly…but I am sorry to say that I can’t reproduce your graph with the instructions given so that I can do this with other graphs. I have created the bogus data and dragged same to chart. But thats as far as I get. If I select the series and press control&lower case L nothing happens…I never get to a screen that I can change to a secondary axis…sorry to be dense, but any additional newbie instruction is welcome. THANKS,

Reply | Quote

The keyboard shortcut Jan Karel mentioned was not Ctrl+L but Ctrl+1 (the number one).

Reply | Quote

And this is the dialog you should be seeing after control-1 (and after changing the axis to secondary axis)

Reply | Quote

Thank you! I can now re-produce the graph that you did for me originally…again, thanks for not only for solving my problem, but helping me understand the approach so that I can use it again in the future. Take care.

Reply | Quote