|
||||||||||||||||||||
|
|||||||||||||||||||||
|
|||||||
| Notices |
 |
|
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
08-23-2008, 12:48 AM
|
|||
|
|||
|
graphing two sets of data on same graph
This should be easy to do but I can't figure it out.
I have two sets of data I'm trying to put in a line graph. They both have the same x-axis which is "date". And both sets of data even have the same values for date. The y-axis is temperature and this is the only point in which they differ. However, when I graph in a series, only one set of data has the proper y-axis values. The other one is on the graph but it is not plotted at the right temperature points. How do I get both graphs to graph with the right y-axis values? I have attached the chart. 
|
|
#2
08-23-2008, 08:24 AM
|
||||
|
||||
|
The chart type is incorrect.
You have used Stacked Line chart, which places the second series above the first. Change the chart sub-type to normal Line with markers.
|
|
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Chossing data for graph | Adseder | Excel Programming | 1 | 06-25-2008 04:52 PM |
| Various macro issues linked to DDE | JMann | Excel Programming | 6 | 05-16-2008 09:08 AM |
| merging and consolidating two data sets | ianmacneil | Excel Worksheet Functions | 2 | 10-19-2007 04:02 PM |
| Graph from Imported Data | LWCARAB | Excel General | 2 | 09-12-2007 12:42 PM |
| Graph from imported data | LWCARAB | Excel Worksheet Functions | 0 | 09-12-2007 07:29 AM |
Linear Mode
