View Single Post
  #5   Report Post  
mackie99
 
Posts: n/a
Default

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

"Bernard Liengme" wrote:

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

"mackie99" wrote in message
...
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.