+ Reply to Thread
Results 1 to 9 of 9

Excel Stacked Area Chart

  1. #1
    Registered User
    Join Date
    01-17-2013
    Location
    asia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Question Excel Stacked Area Chart

    Dear All,

    How to make axis value like dataset. I have attached the picture.

    Appreciate for your help.


    Regards,
    Andre


    stucked_area_chart.jpg

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

    Re: Excel Stacked Area Chart

    Use a dummy series to display axis labels of choice.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-17-2013
    Location
    asia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Excel Stacked Area Chart

    Hi Andy,

    How about for Y axis?

    Thank you

    Cheers,

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

    Re: Excel Stacked Area Chart

    Exactly the same principle but swap the x data to be zeros and use real y data.

  5. #5
    Registered User
    Join Date
    01-17-2013
    Location
    asia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Excel Stacked Area Chart

    Hi Andy,

    I have tried dummy for Y axis but how about stucked area still does not work.

    Appreciate your help.

    Cheers,

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

    Re: Excel Stacked Area Chart

    Not sure what you mean by stucked area.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    01-17-2013
    Location
    asia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Excel Stacked Area Chart

    Hi Andy,

    Please find out attached. Thanks!

    1087411c.xlsx

  8. #8
    Registered User
    Join Date
    01-17-2013
    Location
    asia
    MS-Off Ver
    Excel 2010
    Posts
    14

    Re: Excel Stacked Area Chart

    I mean that how to hatch area..
    Attached Files Attached Files

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

    Re: Excel Stacked Area Chart

    You can add a series, move to secondary axis, change chart type to area.
    Add secondary horizontal axis and set it to display dates.

    You will need to factor up the x values as dates are plotted as whole numbers and your data is percentages.
    Attached Files Attached Files

+ 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: 12-16-2014, 12:47 PM
  2. A Challenge: 100% Stacked area chart
    By ajm123456789 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2012, 02:40 PM
  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. True 3D Stacked Area Chart
    By rsw1941 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-06-2007, 04:39 PM
  5. 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