+ Reply to Thread
Results 1 to 4 of 4

90 Degree Break At Start of Stacked Area Chart

  1. #1
    Registered User
    Join Date
    01-18-2012
    Location
    Los Angeles USA
    MS-Off Ver
    Excel Office 365
    Posts
    80

    90 Degree Break At Start of Stacked Area Chart

    I am creating a scatter combo chart with an x-y chart and a stacked area chart on it.
    I want the stacked area chart to ignore the previous 0 points and show a 90-degree angle at the first non-zero data point, not a slope going from 0 at x=3 to the x=4 data value.
    The stacked area chart data will be starting down the x-axis, not at x=0.
    I tried 0, '' and na() for the blank data but no luck.
    Thanks

    Sloped Area Before.png Sloped Area After.png
    Attached Images Attached Images
    Last edited by laguna92651; 03-26-2024 at 06:12 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: 90 Degree Break At Start of Stacked Area Chart

    Instead of 0 use =NA() for non-plotting area chart

    See attached file
    Attached Images Attached Images
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    01-18-2012
    Location
    Los Angeles USA
    MS-Off Ver
    Excel Office 365
    Posts
    80

    Re: 90 Degree Break At Start of Stacked Area Chart

    Thanks, Kaper
    I replicated your chart with the 90-degree leading edge. When I change the area chart to a stacked area chart, I get the sloped leading edge. Do you have any ideas on how to fix that?
    Thanks again
    Al

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

    Re: 90 Degree Break At Start of Stacked Area Chart

    IMO, this is the definitive tutorial for how Excel charts handle blank cells (and how N/A offers a substitute for blank cells): https://peltiertech.com/plot-blank-c...-excel-charts/ Towards the end of the tutorial, Peltier describes the behavior of stacked charts. Pulling out one statement from the beginning of this section
    Quote Originally Posted by Jon Peltier
    If you are trying to plot an empty cell as a gap, and it isn’t working, make sure you aren’t using a stacked chart type.
    Of course, there's probably a reason you want a stacked area chart here. We might be able to help better if you will explain what the stacked area chart is doing and why it is essential.

    My gut instinct is that, if both a stacked area and a vertical "gap" are essential parts of this chart, you are probably going to need to revert to the techniques described in this tutorial: https://peltiertech.com/excel-area-chart-with-gap/

    Look over that and see what you think. Then let us know how you want to proceed and how we can help.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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 column chart combined with 2d area chart
    By TEABAG in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-31-2022, 05:01 PM
  2. Replies: 5
    Last Post: 12-09-2015, 12:41 PM
  3. Replies: 2
    Last Post: 12-16-2014, 12:47 PM
  4. [SOLVED] How to fix slope at start of the stacked area chart
    By kswonder in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 07-14-2014, 11:59 AM
  5. A Challenge: 100% Stacked area chart
    By ajm123456789 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2012, 02:40 PM
  6. Series Chart Type Area or Stacked Area?
    By Dangerruss in forum Excel General
    Replies: 1
    Last Post: 07-01-2010, 11:41 PM
  7. [SOLVED] Stacked area and area chart combo
    By [email protected] in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 08-18-2006, 09:35 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