Display Y axes on both sides of chart?

F

Febra

Is there a way to display the scale for the Y axes on the left and the right
side of a chart?
Thanks,
Febra
 
B

Bernard Liengme

You can specify second Y axis when you have two data series.
If you have only one, then make a copy in adjacent column (=B2 etc) and
chart his as second data series.
Come back if you need more details

best wishes
 
F

Febra

I think I may be wording my question wrong. What I am wanting is for the
scale of the chart to display on both the left an right sides of the chart.
Is that possible?
Thanks,
Febra
 
B

Bernard Liengme

I should have said that when you have a secondary y-axis it is displayed on
the right. Now if you plot the same series twice and specify secondary axis
for one of them, you will achieve your objective.

best wishes
 
J

Jon Peltier

Febra -

What Bernard is saying is that a primary axis will only appear on one side of the chart. To get
another axis on the other side, you need to create a secondary axis. If you scale both axes the
same, it will appear to the viewer that you have provided the primary axis on both sides of the
chart.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic Way to have Equal Scales on X-Y Plots ? 0
Changing the setting of X,Y axes 0
shrinked Y-axes 0
three y axes 2
Help with area under trendline 0
how to switch the primary and secondary Y axis to opposite chart s 2
Unwanted chart plot area resized when .Axes(xlValue).MinimumScale = "-0.1" 0
Custom Format numbers for learning chart 0

Top