A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Chart w/two different data sets



 
 
Thread Tools Display Modes
  #1  
Old October 22nd, 2004, 02:10 PM
external usenet poster
 
Posts: n/a
Default Chart w/two different data sets

I have a set of data which is an set of data points taken through out
a 24 hour period.

The sets are broken up into 3 sets (10 hours, 10 hours, and 4 hours).
I'm trying to create one bar graph which combines the 3 sets into one
24 hour x-axis.

I'm having problem getting the data ranges set. How do I select data
ranges from 3 seperate areas?

I can reformat the data but I need to do this with a lot of different
data sets. I'm trying to set up the graph once and reuse it multiple
times.

Any idea?

Thanks
  #2  
Old October 25th, 2004, 02:40 AM
Jon Peltier
external usenet poster
 
Posts: n/a
Default

Just checking: You have three sets of X and Y data? One goes from 0:00 to 9:59, the
next 10:00 to 19:59, the third 20:00 to 23:59? It's unfortunate that they have been
broken up. Have you at least kept the corresponding times and Y values in adjacent
columns?

To make your chart, select the first set, the 0:00 to 9:59 times (X values) and the
corresponding Y values. Start the chart wizard, and create an XY Scatter chart (not
a Line chart). Here's the first 10 hours. Select and copy the second set of data,
select the chart, and from the Edit menu, choose Paste Special, with the New Points
and Categories in First Column options. This adds the points to the existing series.
Select, Copy, and Paste Special the third set of data in the same way.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

wrote:

I have a set of data which is an set of data points taken through out
a 24 hour period.

The sets are broken up into 3 sets (10 hours, 10 hours, and 4 hours).
I'm trying to create one bar graph which combines the 3 sets into one
24 hour x-axis.

I'm having problem getting the data ranges set. How do I select data
ranges from 3 seperate areas?

I can reformat the data but I need to do this with a lot of different
data sets. I'm trying to set up the graph once and reuse it multiple
times.

Any idea?

Thanks


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2000 "Dead" Chart Links Phoenix Charts and Charting 4 September 16th, 2004 07:51 PM
Embed data in graph wrace Charts and Charting 5 May 5th, 2004 04:39 AM
chart with changing data source interactive chart Feketik Charts and Charting 1 March 19th, 2004 10:26 AM
Pivot Chart affected when refresh data Ailing Charts and Charting 1 January 15th, 2004 12:20 PM
Chart Data Earl Kiosterud Worksheet Functions 0 October 16th, 2003 03:25 PM


All times are GMT +1. The time now is 08:21 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.