+ Reply to Thread
Results 1 to 3 of 3

Stacked Line Chart Lines not matching the actual values

  1. #1
    Forum Contributor
    Join Date
    06-26-2014
    Location
    Houston
    MS-Off Ver
    365
    Posts
    196

    Stacked Line Chart Lines not matching the actual values

    Hey everybody,

    I have a stacked line chart, and the lines do not match up with the actual data. Example, on 11/1/2016, the value for deeprock74 is 524.81, but on the chart, the point representing the value on that date is more like 5,000. Also, the data points for deeprock71, deeprock73, and deeprock 74 on 11/6/2016 are all the same point on the chart, yet the values are all different. What am I doing wrong? It looks like deeprock74 on the chart may actually be the Grand Total column from the pivot table.
    Attached Images Attached Images

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

    Re: Stacked Line Chart Lines not matching the actual values

    The chart looks exactly like what I would expect for a "stacked" line chart. The value for the first data series is that value (1070) above the x axis. The second data series is its value above the first data series (1070+340=1410), and so on up the chart. Which means that the final data series should track the values for the grand total, as you noted.

    Since this is standard behavior for a stacked line chart, did you really intend to create a stacked line chart? Perhaps you are looking for a regular line chart rather than a 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
    06-26-2014
    Location
    Houston
    MS-Off Ver
    365
    Posts
    196

    Re: Stacked Line Chart Lines not matching the actual values

    You sir, are a genius.

+ 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: 8
    Last Post: 06-12-2015, 04:23 PM
  2. [SOLVED] Vertical bar chart (stacked bar chart): How to use lines?
    By lukelucky in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-11-2015, 11:35 AM
  3. Combo chart - line graph and stacked column - lines not visible
    By marilyn23 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-02-2014, 12:24 AM
  4. [SOLVED] Stacked column chart always represents smaller values than actual
    By RagingPenguin4 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2013, 11:56 AM
  5. [SOLVED] Display vertical line on stacked line chart already using primary and secondary axises
    By ben_hensel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-05-2012, 10:21 AM
  6. actual number acheived,:Stacked Bar Chart
    By jonny_lufc in forum Excel General
    Replies: 1
    Last Post: 01-07-2011, 08:32 AM
  7. [SOLVED] Combine stacked column and line chart w/series lines
    By ancillaries in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2006, 06:55 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