+ Reply to Thread
Results 1 to 6 of 6

Change Colour of 1 section on Area Stacked Chart- New Stacked Area Chart

  1. #1
    Registered User
    Join Date
    01-15-2015
    Location
    London
    MS-Off Ver
    7
    Posts
    32

    Change Colour of 1 section on Area Stacked Chart- New Stacked Area Chart

    Hi All,

    I have a stacked area Chart with the below data, the issue is I would like Dec-15 and Jan-16 shaded in a color only--- I have trying to achieve this for hours? Please help

    Net Revs Total costs
    Nov-14 561 506
    Dec-14 518 481
    Jan-15 497 451
    Feb-15 437 480
    Mar-15 565 495
    Apr-15 503 491
    May-15 536 472
    Jun-15 591 474
    Jul-15 512 500
    Aug-15 525 502
    Sep-15 585 507
    Oct-15 606 500
    Nov-15 473 500
    Dec-15 381 550
    Jan-16 368 550

    Any help is appreciated!

    Many Thanks

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Change Colour of 1 section on Area Stacked Chart- New Stacked Area Chart

    Quote Originally Posted by OP
    I would like Dec-15 and Jan-16 shaded in a color only
    ??

    Shaded how? You want the area for those to be in color while the rest are in black-and-white? You want the background for those two months to be colored in?
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    01-15-2015
    Location
    London
    MS-Off Ver
    7
    Posts
    32

    Re: Change Colour of 1 section on Area Stacked Chart- New Stacked Area Chart

    hi, yes i need the background just for Dec 15 and Jan 16 to be in colour or just to stand out from the rest of the months....

  4. #4
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Change Colour of 1 section on Area Stacked Chart- New Stacked Area Chart

    Alright try out the attached, it's a stacked area chart with a helper series to create highlighter columns for selected months.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-15-2015
    Location
    London
    MS-Off Ver
    7
    Posts
    32

    Re: Change Colour of 1 section on Area Stacked Chart- New Stacked Area Chart

    Thanks very muc, I will try this and see if it works with after manipulating the data.... the shaded part- is there any way we can change it from the bar column to match the shaded area... maybe a long shot...

  6. #6
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Change Colour of 1 section on Area Stacked Chart- New Stacked Area Chart

    Quote Originally Posted by pidnani View Post
    the shaded part- is there any way we can change it from the bar column to match the shaded area...
    I don't really understand what you're asking for here.

    I just went quick-and-easy riffing off a trick I picked up from John Peltier; there are ways to message it to get it closer to the exact appearance you want.

+ 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. Excel Stacked Area Chart
    By geomo in forum Excel General
    Replies: 8
    Last Post: 06-13-2015, 08:18 AM
  2. Replies: 2
    Last Post: 12-16-2014, 12:47 PM
  3. A Challenge: 100% Stacked area chart
    By ajm123456789 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-02-2012, 02:40 PM
  4. Series Chart Type Area or Stacked Area?
    By Dangerruss in forum Excel General
    Replies: 1
    Last Post: 07-01-2010, 11:41 PM
  5. Stacked Area Chart Series Colour Change
    By downunderthunder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-06-2010, 09:18 PM
  6. True 3D Stacked Area Chart
    By rsw1941 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-06-2007, 04:39 PM
  7. 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