Secondary axis on graph

M

Mary Fran

I am plotting 2 y-values for each x value and am wondering how to add a
secondary y-axis on the right of the graph to show the different range of y
values. Thanks for any help.
 
D

Duane Hookom

Actually, you can double-click to open the chart design. Select the series
that you want on the secondary scale and right-click and choose Format Data
Series. Choose the Axis tab and select the Secondary Axis option. This
should create an automatic scale on the right side of the chart for your
second series.
 
M

Mary Fran

I can't seem to double-click anywhere in the chart that when I right-click
I'm given the opportunity to Format Data Series. I see that wherever you
double-click you are presented different options depending on the object you
double-clicked, but can't figure out where to get that secondary scale
option. Thanks for your continued assistance in this matter.
 
M

Mary Fran

I figured it out! Please disregard previous post and thanks for pointing me
in the right direction!
 
Top