Chart w/two different data sets

  • Thread starter Thread starter adc31555
  • Start date Start date
A

adc31555

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
 
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/
_______
 
Back
Top