OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

[Help] How to get two similar ranges into one chart?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Aacron
Newbie
Newbie


Joined: 25 Oct 2010
Posts: 2

PostPosted: Mon Oct 25, 2010 9:20 pm    Post subject: [Help] How to get two similar ranges into one chart? Reply with quote

I've been searching around on the 'net and haven't come up with a decent way to do this:

I have a spreadsheet with 3 sheets -- "Escort", "Ranger", and "Chart".

The Escort and Ranger sheets are data for each vehicle's fuel use, using the following data: Date, Gallons, Miles, Price, Miles per Gallon, Price per Mile, Station Bought At.

Right now, on the 'Chart' sheet, I have two graphs showing the MPG and PPM for each vehicle. What I'd like to do and can't figure out how, is two combine the two graphs so that I can compare the vehicles a little easier. The only way I could get the data on the chart in any way close to what I wanted it was showing the information, but not keeping both ranges in sync for the date.

Is this possible? Do I need another sheet to combine the data for the chart with some magic thrown in so it makes sense and does what I'm asking of it?

I'd appreciate any help, and thank you in advance!
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Tue Oct 26, 2010 1:53 am    Post subject: Re: [Help] How to get two similar ranges into one chart? Reply with quote

Aacron wrote:
I've been searching around on the 'net and haven't come up with a decent way to do this:

I have a spreadsheet with 3 sheets -- "Escort", "Ranger", and "Chart".

The Escort and Ranger sheets are data for each vehicle's fuel use, using the following data: Date, Gallons, Miles, Price, Miles per Gallon, Price per Mile, Station Bought At.

Right now, on the 'Chart' sheet, I have two graphs showing the MPG and PPM for each vehicle. What I'd like to do and can't figure out how, is two combine the two graphs so that I can compare the vehicles a little easier. The only way I could get the data on the chart in any way close to what I wanted it was showing the information, but not keeping both ranges in sync for the date.

Is this possible? Do I need another sheet to combine the data for the chart with some magic thrown in so it makes sense and does what I'm asking of it?
No need to make an extra sheet.
As long as the data is in the same sequence on your sheets, you should be able to add a new data range, selecting the appropriate range from any sheet for the Y values.
  • Double click to activate Chart editing.
  • Right click the chart and select data range.
  • Select the Series tab, and add a data series.
  • Select Y-values, then tick your data range.
The exact procedure may vary a little, depending on type of chart.
Back to top
View user's profile Send private message
Aacron
Newbie
Newbie


Joined: 25 Oct 2010
Posts: 2

PostPosted: Tue Oct 26, 2010 8:44 am    Post subject: Reply with quote

That is what I did before, and although it does get the data into the chart, it is not arranging it by date.

The Escort is from 05/14/2010, while the Ranger starts at 09/27/2010, as I recently bought the vehicle.

When I put the new data series into the chart, the Ranger data starts at the left of the chart, when it should be starting near the end.
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Tue Oct 26, 2010 11:47 am    Post subject: Reply with quote

If you need data arranged by date, it has to be an X/Y chart. With that, each data series has its own range for X and Y values (as opposed to bar charts which share a common label set for the X axis). For that to work, your dates have to be entered as spreadsheet date values, not text (if you entered them manually and did not get any ready made template from others, all should be well)
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group