How can i produce a 2 sided graphs

G

GuyMac

I need to produce within the same graph two y scales one on the right and one
on the left
 
T

trip_to_tokyo

I have just put up a file for you at:-

http://www.pierrefondes.com/

It is item number 61 towards the top of my home page.

This is one example on one way in which to do what you want.

There are, of course, various ways to do this depending upon your
requirements.

Please hit Yes if my comments have helped.

Thanks.
 
A

AdamV

Rather than visit another website and download a file to find out the
method, the one line answer you need is format one of your data series
and then choose "Plot series on Secondary Axis"
(right click > format or use the chart toolbar / layout ribbon to select
the series and click the button to format).

Once you have a secondary axis you can format this as you choose, fix
the scale etc.

Hope this helps
Adam
 

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

Combining a 2-D column graph and a 2-D line graph on the same char 3
Excel graphs change when pasted into Publisher - Metafiles change? 0
How can I create my own template for graphs for easy reuse? 1
Dual Vertical Y-Axis 2
How to insert 2 scales on y-axis? 3
Dynamic graph issue 2
How do I produce a graph with 2 x-axes and 1 common y-axis? 3
Insert multiple .dat files into one pdf without losing color of their graphs 0

Top