G
Guest
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
What do I highlight? please walk me through this .thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Andy Pope
Hi,
This explains how to display the secondary axes.
http://www.andypope.info/tips/tip008.htm
Cheers
Andy
This explains how to display the secondary axes.
http://www.andypope.info/tips/tip008.htm
Cheers
Andy
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/
_______
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
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/
_______
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/
_______
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
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
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/
_______