Excel 2000 charts/graphs

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

rudgv1

Thread Starter
Joined
Oct 31, 2001
Messages
1
I need to create a graph (line) with two feilds of data. Simple eh? But the data has different figures which go on the category axis. I need the figs for petrol and deisel on the same graph but the engines sizes are different (eg there is no 2.2 in petrol only in deisel) How can I get the info on the same axis and the points that correlate correct. PLS help!!!
 

Anne Troy

Anne
Joined
Feb 14, 1999
Messages
11,751
Try this:

Create the graph normally. Then, double-click right on the line for that second deisel. Format series should come up. Click on the Axis tab and choose "secondary axis".
 
Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top