+ Reply to Thread
Results 1 to 5 of 5

wrong showing Chart value

  1. #1
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    wrong showing Chart value

    Hi Experts,

    I have issue on chart, value is 3 but chart line is going on 10, can any one help on this issue, I have attached screenshot and excel file.

    Thanks for advance.

    Farhan
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: wrong showing Chart value

    The chart looks correct to me -- where your two line chart series are specified as stacked line chart. Perhaps you intended those two line chart series to be regular line chart rather than stacked line chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: wrong showing Chart value

    please cehck the screenshot which I have posted in 1st post, 3 value is showing on 10 line.

  4. #4
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: wrong showing Chart value

    anyone help me on this issue?

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: wrong showing Chart value

    You have been given the answer by MrShorty. You need to change the type for that series from a stacked line chart to a regular line chart.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Excel Chart Date is Showing Wrong Date
    By azmir in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-22-2016, 04:45 AM
  2. Help! Area chart is showing my data wrong!
    By ayrobotech in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-10-2016, 07:17 PM
  3. Excel Chart Showing Wrong Month
    By rtabaldi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2013, 05:25 AM
  4. [SOLVED] Total SUM Value - Showing the wrong value
    By RhoniMohanraj in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-05-2013, 01:23 AM
  5. Replies: 4
    Last Post: 01-01-2013, 05:00 PM
  6. Excel 2007 : Chart showing wrong if cell is blank
    By sherifpv in forum Excel General
    Replies: 6
    Last Post: 05-31-2011, 03:49 AM
  7. Wrong Sum() Showing
    By ChrissyHof in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-28-2007, 02:17 PM

Tags for this Thread

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