Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up secondary axis on bar graph. What do I highlight?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up secondary axis on bar graph. What do I highlight?
Hi,
This explains how to display the secondary axes. http://www.andypope.info/tips/tip008.htm Cheers Andy inquiringmind73 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up secondary axis on bar graph. What do I highlight?
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/ _______ "Andy Pope" wrote in message ... Hi, This explains how to display the secondary axes. http://www.andypope.info/tips/tip008.htm Cheers Andy inquiringmind73 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up secondary axis on bar graph. What do I highlight?
Hi Jon,
Not sure I understand. The example is a two series chart and the instructions say use the second series. Cheers Andy Jon Peltier wrote: 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/ _______ "Andy Pope" wrote in message ... Hi, This explains how to display the secondary axes. http://www.andypope.info/tips/tip008.htm Cheers Andy inquiringmind73 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up secondary axis on bar graph. What do I highlight?
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" wrote in message ... Hi Jon, Not sure I understand. The example is a two series chart and the instructions say use the second series. Cheers Andy Jon Peltier wrote: 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/ _______ "Andy Pope" wrote in message ... Hi, This explains how to display the secondary axes. http://www.andypope.info/tips/tip008.htm Cheers Andy inquiringmind73 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I set up secondary axis on bar graph. What do I highlight?
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 Peltier wrote: 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" wrote in message ... Hi Jon, Not sure I understand. The example is a two series chart and the instructions say use the second series. Cheers Andy Jon Peltier wrote: 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/ _______ "Andy Pope" wrote in message ... Hi, This explains how to display the secondary axes. http://www.andypope.info/tips/tip008.htm Cheers Andy inquiringmind73 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Secondary "X" axis with different description | Charts and Charting in Excel | |||
Secondary Axis | Charts and Charting in Excel | |||
Secondary Axis Match Primary Axis Gridlines | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
How do I set permanent secondary axis in PivotTable chart? | Charts and Charting in Excel |