+ Reply to Thread
Results 1 to 2 of 2

Excel coloring forecast area

  1. #1
    Registered User
    Join Date
    07-14-2021
    Location
    Hamburg, Germany
    MS-Off Ver
    Office for Mac 2019
    Posts
    1

    Excel coloring forecast area

    Dear forum members,

    for the last couple of hours I have been trying to color the upper and lower area of a forecast. I have been able to color the upper part but struggling to color the lower part as well, see attached screen shot.

    Do you have an idea / solution how to color the lower part as well?

    Thanks a lot for your help and sorry for my bad English, its not my mother tongue.

    W0rldTrav3l3r
    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,814

    Re: Excel coloring forecast area

    What kind of technique are you using to color the upper part? A stacked area chart? I would expect to use the same kind of technique for the lower part.

    It is difficult for us to help much from just a picture. Can you upload a sample spreadsheet that shows what you have now and explains what you are trying to do?
    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. Coloring area based on values
    By JoakimBugge in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2020, 07:50 AM
  2. Waterfall Chart with automatic coloring and text coloring
    By amartino44 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-19-2013, 05:54 PM
  3. Area Chart with Actual and Forecast Data
    By lespaul00 in forum Excel General
    Replies: 0
    Last Post: 07-02-2012, 11:53 AM
  4. Excel 2007 : Coloring area in line chart
    By SoftwareTester in forum Excel General
    Replies: 1
    Last Post: 04-16-2010, 04:25 AM
  5. Custom Coloring an area chart with VBA
    By mattdick in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-06-2009, 11:24 AM
  6. Shading / coloring a target area on a line plot
    By anagaraj1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-16-2008, 02:57 PM
  7. Coloring Chart Area Dynamically?
    By silver23 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-27-2005, 12:05 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