Excel question
Excel question
Registered User
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
Right click on the graph and select "Source Data". Look at the "Series" tab; it gives you the option of adding additional series to the graph. Click "Add", then enter the title and range for the new graph. Depending on the type of graph you have you may need new abscissa data (e.g., a scatter plot type) or you may not.
Hope this helps.
Hope this helps.
Thread Starter
Registered User
Joined: Jun 2003
Posts: 4,358
Likes: 1
From: It's a secret!
What happens if you need a different scale for the new data?
Think of two bell-shaped curves, one centered around 3 and the other around 15. If the original graph only has the bottom "scale" going from 0 to 6, how can you get it to expand?
Think of two bell-shaped curves, one centered around 3 and the other around 15. If the original graph only has the bottom "scale" going from 0 to 6, how can you get it to expand?
Registered User
Joined: Jul 2001
Posts: 6,592
Likes: 0
From: Yorba Linda, CA
I'd say that the best thing to do is plot the original as a scatter plot, where you specify the data for the x-coordinates as well as for the y-coordinates. When you add the new data as I outlined above, you'll put in x-coordinates and y-coordinates for the second curve, and the scale will adjust to the new data.
Let me know if this helps.
Let me know if this helps.
Registered User
Joined: Oct 2000
Posts: 4,193
Likes: 0
From: Denton, Texas
Originally Posted by JerseyGirl,Oct 3 2004, 07:01 PM
What happens if you need a different scale for the new data?
Think of two bell-shaped curves, one centered around 3 and the other around 15. If the original graph only has the bottom "scale" going from 0 to 6, how can you get it to expand?
Think of two bell-shaped curves, one centered around 3 and the other around 15. If the original graph only has the bottom "scale" going from 0 to 6, how can you get it to expand?
Registered User
Joined: Jan 2004
Posts: 4,938
Likes: 0
From: limerick
<---- This is why I have this screen name
Two bits of info for you
You can manually set the scale by right clicking the axis select format axis select scale un check the boxes for max and min and ennter your own scale
If so some strange reason you would need to superimposed on scale on anouther, for what reason I have no idea since then you should just creat two graphs, you can format both the chart area, plot area and walls to area->none Making all of the back ground transparent and then placing the graph on top of one. make sure you set it order to front. If you need any further assistance or a better clearification of the steps please feel free to PM me.
You can set two different scales for a graph one for the primary axis and one for the secondary! Some graph types do not support the secondary axis
Two bits of info for you
You can manually set the scale by right clicking the axis select format axis select scale un check the boxes for max and min and ennter your own scale
If so some strange reason you would need to superimposed on scale on anouther, for what reason I have no idea since then you should just creat two graphs, you can format both the chart area, plot area and walls to area->none Making all of the back ground transparent and then placing the graph on top of one. make sure you set it order to front. If you need any further assistance or a better clearification of the steps please feel free to PM me.
You can set two different scales for a graph one for the primary axis and one for the secondary! Some graph types do not support the secondary axis
Thread
Thread Starter
Forum
Replies
Last Post