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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |