why can I not format a secondary axis in excel x?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Despite being able to graph data on a secondary axis in Microsoft Excel X, I
have been unable to format said axis (ie make it start from a value other
than zero). No amount of trying to click on and select the axis or the
values has helped.
 
Are you saying that double clicking does not bring up the Format dialog box
for the axis?
Try tapping the 'navigation (arrow) keys while watching the Name box. When
it reads Secondary Value.... use the Format menu item to open the dialog box
and then open the Scale tab to set the Min and Max values

best wishes
Bernard
 
Mackie -

What kind of axis did you add? Is it a category axis? You will not be able to set
too many scale options for a category axis (as opposed to a value axis). Select
Chart Options from the Chart menu, and click on the Axes tab, to change the type of
axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Yes, I have been unable to select the secondary axis for editing. Using the
arrow keys did not work either, only the primary y axis was an option.
Nothing happens when I double-click the secondary axis values, and right
clicking on them (when the mouse reads 'secondary axis') produces no results
either.

I know it is possible to format, because I previously made a graph with
values from 17-20 (rather than 0-20) but when I cut and paste the graph and
change the data series, it refuses to format anything other than the 0-20
range.

Mackie
 
Back
Top