+ Reply to Thread
Results 1 to 3 of 3

Vertical Axis in Pivot Line Chart Is not Tally

  1. #1
    Registered User
    Join Date
    08-04-2015
    Location
    Malaysia
    MS-Off Ver
    Microsoft Office 365
    Posts
    57

    Vertical Axis in Pivot Line Chart Is not Tally

    test1.png

    I based on simple data to create a pivot line chart.
    However my estimate line value dated 22/7/19 is 200 (1st point) but it located in between vertical axis value between 350 to 400.

    Is there any mistake i make caused the line chart like that??
    How to correct it?

    Thanks.
    Attached Files Attached Files
    Last edited by ulala2; 08-02-2019 at 12:11 AM.

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

    Re: Vertical Axis in Pivot Line Chart Is not Tally

    I don't know why this is a common mistake, but it looks like you have chosen a stacked line chart, when you intended to ues a regular line chart (173+200 isabout 373, which is close to where the point is plotted). If you change your chart type to line instead of stacked line, you shouyld get what you want.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    08-04-2015
    Location
    Malaysia
    MS-Off Ver
    Microsoft Office 365
    Posts
    57

    Re: Vertical Axis in Pivot Line Chart Is not Tally

    Quote Originally Posted by MrShorty View Post
    I don't know why this is a common mistake, but it looks like you have chosen a stacked line chart, when you intended to ues a regular line chart (173+200 isabout 373, which is close to where the point is plotted). If you change your chart type to line instead of stacked line, you shouyld get what you want.
    Dear Mr.Shorty,
    Thanks for the advise.
    Your answer solved the issue. It is my mistake selected the stacked line chart instead of normal line chart.

+ 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. Replies: 2
    Last Post: 06-28-2019, 03:35 AM
  2. Replies: 1
    Last Post: 01-01-2018, 07:25 AM
  3. Replies: 1
    Last Post: 01-01-2018, 07:21 AM
  4. Replies: 2
    Last Post: 09-03-2013, 09:18 AM
  5. How to insert in the pivot chart a vertical line
    By grossi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-17-2012, 10:00 PM
  6. Replies: 0
    Last Post: 07-13-2005, 05:05 PM
  7. How to insert in the pivot chart a vertical line
    By in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-01-1970, 12:00 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.6.0 RC 1