+ Reply to Thread
Results 1 to 2 of 2

Adding shading to an excel chart

  1. #1
    Registered User
    Join Date
    08-18-2016
    Location
    Australia
    MS-Off Ver
    Microsoft Office Home and Business 2013
    Posts
    5

    Question Adding shading to an excel chart

    Hello,

    I was wondering if there is a way to add background shading to an excel chart. I have a plot which shows 'distance in kilometres' on the x axis and 'water depth' on the y axis for two different time periods. I want to be able to shade the area between 0-185 kilometres as 'non weir pool' and the area between 185-270 kilometres as 'weir pool'. OR alternately I could live with just shading the area between 185-270. Any suggestions??


    THANKS
    M
    Attached Files Attached Files

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

    Re: Adding shading to an excel chart

    A couple of possible ideas:

    1) This tutorial uses a stacked bar chart to create vertical shaded bands. The main chart is also a bar chart in the tutorial, but it should be fairly straightforward to adapt to a scatter+stacked bar type chart. https://peltiertech.com/Excel/Charts...ticalBand.html

    2) This tutorial uses a stacked area chart to create the background effect. https://peltiertech.com/shaded-quadr...scatter-chart/ If you have trouble adapting the previous tutorial, this one might be easier because it starts with a scatter chart.

    One of those approaches should adapt to what you want 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. [SOLVED] code is adding unintended shading and formatting
    By BioBCCK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2018, 12:04 PM
  2. [SOLVED] Shading areas between xy chart
    By majana54 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 04-13-2017, 10:49 AM
  3. [SOLVED] Adding Check Box 3D Shading to a Macro
    By madger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2014, 11:10 AM
  4. Shading of an excel chart and doing a calculation of the shaded area
    By Rob (SA) in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-12-2013, 01:11 PM
  5. Shading in a bubble chart
    By NeoFlex in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-12-2012, 04:08 PM
  6. Selective Shading in a Chart
    By andrw313 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-26-2012, 01:52 PM
  7. Excel Progress Chart - Shading Plot Area
    By slash_gnr3k in forum Excel General
    Replies: 0
    Last Post: 04-13-2011, 10:51 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