[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
Aacron
Newbie

Joined: 25 Oct 2010
Posts: 2

 Posted: Mon Oct 25, 2010 9:20 pm    Post subject: [Help] How to get two similar ranges into one chart? 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!
keme
Moderator

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

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

 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.
Aacron
Newbie

Joined: 25 Oct 2010
Posts: 2

 Posted: Tue Oct 26, 2010 8:44 am    Post subject: 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.
keme
Moderator

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

 Posted: Tue Oct 26, 2010 11:47 am    Post subject: 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)
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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