Graphing Question

P

petevang

I'm trying to graph a 2005 company trend showing dollars and numbers.
The dollar amount is in the millions and the number amount is in th
low 100's. How can I graph both lines on the same chart? When I tr
to graph them as separate series the number trend basiclly lies on to
of the x axis. I'd like to be able to see both of them on the sam
graph
 
A

Andy Pope

Hi,

Plot one of the lines on the secondary Y axis. To do this double click
one of the series and on the Axis tab of the Format Dialog choose
secondary axis.

Cheers
Andy
 

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
Multiple Line Graphs 5
Best Table Layout 0
Problem creating a logarithmic trend line 2
How do I specify X,Y axis and Series values in a line graph? 5
Excel Graph Problem - Need Help 2
Help with 2007 Chart Layout 1
Odd chart type needed 1

Top