ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   secondary axis problem (https://www.excelbanter.com/excel-discussion-misc-queries/188311-secondary-axis-problem.html)

raventroll

secondary axis problem
 
I'm trying to add a secondary axis in Excel 2007 and am following the help
steps. Only when I get to the part about clicking on "Secondary Axis" under
"Plot Series On" in the "Format Data Series" window, there is no "Plot Series
On" area. Why is help telling me to do something I seemingly can't do?

raventroll

secondary axis problem
 
I figured it out. Apparently you can't add a secondary axis when using a 3-D
chart type.

"raventroll" wrote:

I'm trying to add a secondary axis in Excel 2007 and am following the help
steps. Only when I get to the part about clicking on "Secondary Axis" under
"Plot Series On" in the "Format Data Series" window, there is no "Plot Series
On" area. Why is help telling me to do something I seemingly can't do?


Jon Peltier

secondary axis problem
 
What kind of chart? How many series in the chart?

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

"raventroll" wrote in message
...
I'm trying to add a secondary axis in Excel 2007 and am following the help
steps. Only when I get to the part about clicking on "Secondary Axis"
under
"Plot Series On" in the "Format Data Series" window, there is no "Plot
Series
On" area. Why is help telling me to do something I seemingly can't do?




Jon Peltier

secondary axis problem
 
Take a lesson from this experience and swear off 3D charts. They have worse
issues than merely lack of features.

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


"raventroll" wrote in message
...
I figured it out. Apparently you can't add a secondary axis when using a
3-D
chart type.

"raventroll" wrote:

I'm trying to add a secondary axis in Excel 2007 and am following the
help
steps. Only when I get to the part about clicking on "Secondary Axis"
under
"Plot Series On" in the "Format Data Series" window, there is no "Plot
Series
On" area. Why is help telling me to do something I seemingly can't do?





All times are GMT +1. The time now is 09:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com