+ Reply to Thread
Results 1 to 5 of 5

Line Charts with wrong values

  1. 02-16-2016, 03:06 PM #1
    hcm is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Fort Pierce, Fl
    MS-Off Ver
    Excel 2010
    Posts
    8

    Post Line Charts with wrong values

    Hi,
    I am trying to create a simple chart showing the growth of a database by hours
    Hours are in column B and date in line 2, values are entered by date/time
    The graph produced seemed to double some values, i.e. a value of 75% will be reflected in the graph as 150%
    I tried to reformat the values as numbers, percentage, general, with the same result
    What am I doing wrong??
    Reply With QuoteRegister To Reply
  2. 02-16-2016, 05:30 PM #2
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,957

    Re: Line Charts with wrong values

    Could you please attach a sample spreadsheet, one where sensitive data names (if any) are changed?
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
  3. 02-16-2016, 06:08 PM #3
    MrShorty is online now
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,445

    Re: Line Charts with wrong values

    Any chance you chose a "stacked line graph" instead of a regular line graph when you created the chart?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  4. 02-16-2016, 06:50 PM #4
    hcm is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Fort Pierce, Fl
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Line Charts with wrong values

    sorry, I have issues adding an attachment
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 02-16-2016, 07:10 PM #5
    hcm is offline
    Registered User
    Join Date
    04-30-2013
    Location
    Fort Pierce, Fl
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Line Charts with wrong values

    duh!!! As simple as that!! I couldn't see the forest cuz I was to close to the tree!!!
    Thanks
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Line graph displaying wrong values
    By Leia in forum Excel General
    Replies: 4
    Last Post: 04-20-2011, 08:20 AM
  2. zero values in line charts
    By eric_t_viking in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-02-2009, 08:15 AM
  3. [SOLVED] suppress zero values in line charts?
    By Cruickshank Brothers in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-12-2005, 12:05 AM
  4. How do I hide 0 values in line charts
    By Stephan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-12-2005, 08:06 AM
  5. [SOLVED] line chart displays wrong values
    By koche005 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-26-2005, 06:06 PM
  6. Hiding 0 values in line charts
    By Teri in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-22-2005, 09:06 AM
  7. suppress zero values in line charts?
    By cruickshankbrothers in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-14-2005, 07:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1