+ Reply to Thread
Results 1 to 4 of 4

line graph not plotting correct data

  1. #1
    Registered User
    Join Date
    11-07-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    51

    line graph not plotting correct data

    I have attached a file showing my issue. The data I have ranges from around 40 to about 400 yet the points on the graph are plotted above the 400 range. I'm not sure if there's a setting I'm missing or what else it could be. The column graph is accurate, the line graph is showing off. Thank you in advance for your help!!
    Attached Files Attached Files

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: line graph not plotting correct data

    change your chart type to a line graph not a stacked line graph
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    11-07-2013
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2010
    Posts
    51

    Re: line graph not plotting correct data

    I knew it had to be something simple I was overlooking. Thank you!!!

  4. #4
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: line graph not plotting correct data

    not a problem....I only know because I've done the same thing....have a great day...

    If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Plotting Line Graph for data with lots of gaps
    By theluckygal in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-22-2014, 09:40 AM
  2. Plotting Mean and SD on the same Line graph
    By Katherine133 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-17-2012, 07:11 PM
  3. Plotting complex data to a line graph
    By bootydaddy73 in forum Excel General
    Replies: 1
    Last Post: 09-27-2011, 09:41 AM
  4. Plotting Cummulative Data In A Line Graph
    By tkeith in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-10-2006, 08:40 PM
  5. Plotting Line Graph of Dynamic Data
    By sslack in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-05-2005, 11:05 PM

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.6.0 RC 1