how can i add a secondary y-axis to a bar chart (not a line chart)

E

edbianc

I can't seem to get two data series to plot on two different y-axis when
using vertical bar chart format. If I get the Y-axis to display I only get
one series of data displayed, although the scales of the y-axis are correct
for each data series. The second data series seems to be under the first when
displayed this way, but playing with the option tab settings under format
doesn't bring them out on their own!
 
J

John Mansfield

Edbianc,

Try clicking once on one of the bar series. Then, right-click on your
mouse. In the menu go to Selected Object. In the Format Data Series dialog
box, go to the Axis tab. Choose the "Plot Series on Secondary Axis" option.
 
E

edbianc

John, thanks. But I don't get a selection for "Selected Object" when I right
click.
Only one of the data series bars will give me an axis tab when I right
click, and both series are on top of each other.
 

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

Similar Threads

Use text descriptors as Y axis units 1
vertical scale on both ends of bar chart 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Chart - Secondary Y-axis with different values/scale 2
multiple series bar and line chart 2
Excel 2010 - Line Chart with Mulitiple Data Sets 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
Using the full width of an Excel chart with two Y-axes 2

Top