+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    03-07-2008
    Posts
    86

    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.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944
    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.
    Cheers
    Andy
    www.andypope.info

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. merging and consolidating two data sets
    By ianmacneil in forum Excel Worksheet Functions
    Replies: 3
    Last Post: 08-18-2011, 10:45 PM
  2. Chossing data for graph
    By Adseder in forum Excel Programming
    Replies: 1
    Last Post: 06-25-2008, 04:52 PM
  3. Various macro issues linked to DDE
    By JMann in forum Excel Programming
    Replies: 6
    Last Post: 05-16-2008, 09:08 AM
  4. Graph from Imported Data
    By LWCARAB in forum Excel General
    Replies: 2
    Last Post: 09-12-2007, 12:42 PM
  5. Graph from imported data
    By LWCARAB in forum Excel Worksheet Functions
    Replies: 0
    Last Post: 09-12-2007, 07:29 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0