How do I set up secondary axis on bar graph. What do I highlight?

I

inquiringmind73

I am having trouble adding a secondary axis to a bar graph. Can you help?
What do I highlight? please walk me through this .thanks
 
J

Jon Peltier

Andy -

You should note at the top of your page (tip008.htm) that you need a second
series before you can have a secondary axis. This is a common
misunderstanding.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
A

Andy Pope

Hi Jon,

Not sure I understand. The example is a two series chart and the
instructions say use the second series.

Cheers
Andy

Jon said:
Andy -

You should note at the top of your page (tip008.htm) that you need a second
series before you can have a secondary axis. This is a common
misunderstanding.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Click to expand...
 
J

Jon Peltier

Sure, the example has two series, but it doesn't explicitly mention that two
series is the minimum requirement for two axes. Also, the original post
reminded me of so many that ask for a second axis without realizing a second
series is needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Andy Pope said:
Hi Jon,

Not sure I understand. The example is a two series chart and the
instructions say use the second series.

Cheers
Andy
Click to expand...
 
A

Andy Pope

Fair comment. I think I will add a tip on creating a secondary Y axis
and make reference to that in the secondary X axis tip.

Cheers
Andy

Jon said:
Sure, the example has two series, but it doesn't explicitly mention that two
series is the minimum requirement for two axes. Also, the original post
reminded me of so many that ask for a second axis without realizing a second
series is needed.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Click to expand...
 

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

Graphs: 2 Lines on secondary Y-axis? 1
Make Y-axis values correspond to x- axis value 1
Plotting Line Graphs to Specific Bar Graphs 0
Getting the graph style I want 4
Use text descriptors as Y axis units 1
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1
Plotting Graph with dynamic table 3
Charts created show up different on other computers 0

Top