+ Reply to Thread
Results 1 to 3 of 3

Stacked Area vs regular Area chart behavior when last values in time series are blank

  1. #1
    Registered User
    Join Date
    12-15-2014
    Location
    San Diego, California
    MS-Off Ver
    2013
    Posts
    2

    Question Stacked Area vs regular Area chart behavior when last values in time series are blank

    When plotting a time series with empty values for future dates (in Excel 2013), a regular area chart does what I want -- the shaded area ends abruptly:
    regular area chart.GIF

    When doing the same for a stacked area chart, the shaded area draws a line to zero, which I don't want:
    stacked area chart.GIF

    Any sense of why the different behavior and if it's possible to do what I want?

    (The chart is a 12 week view that fills in a little more each week. I could avoid showing future empty values, but I like showing how many weeks are left until we hit 12, and keeping the scale identical each week. Also, it makes it easy to update without having to manipulate the chart each week.)

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,244

    Re: Stacked Area vs regular Area chart behavior when last values in time series are blank

    To get the shear drop you will need to include a repeat of the last populated data point with zero values.
    This means you can not use the data table, as the extra data points will appear in it.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    12-15-2014
    Location
    San Diego, California
    MS-Off Ver
    2013
    Posts
    2

    Re: Stacked Area vs regular Area chart behavior when last values in time series are blank

    Thanks Andy. That could be a workable solution for me.

+ 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. Stacked Area Chart - Negative Values
    By sagaramlani in forum Excel General
    Replies: 8
    Last Post: 09-05-2012, 12:54 PM
  2. [SOLVED] Stacked area chart with one negative data series needed to be shown separately
    By Ivkosky in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-11-2012, 03:50 AM
  3. Series Chart Type Area or Stacked Area?
    By Dangerruss in forum Excel General
    Replies: 1
    Last Post: 07-01-2010, 11:41 PM
  4. Stacked Area Chart Series Colour Change
    By downunderthunder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2010, 09:18 PM
  5. [SOLVED] Stacked area and area chart combo
    By scott.r.schumacher@boeing.com in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-18-2006, 09:35 AM

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