+ Reply to Thread
Results 1 to 2 of 2

Add shaded bars to seasonal chart to show summer and winter months

  1. #1
    Registered User
    Join Date
    Vancouver, Canada
    MS-Off Ver
    Office 365

    Add shaded bars to seasonal chart to show summer and winter months

    Hello folks,

    I'm making a line graph that shows water consumption fluctuations over several years. Is there a way to make the background of the chart shaded for certain months of the year? For example a light blue shade for winter months and light yellow for summer? This shading would of course be behind the trend line.

    I've added a sample excel sheet.

    Please note this is my second post on this forum. I'm still learning my way around.

    Kind regards,
    Last edited by cameronclimbs247; 05-26-2022 at 02:47 PM.

  2. #2
    Forum Guru
    Join Date
    North America
    MS-Off Ver
    2002/XP and 2007

    Re: Add shaded bars to seasonal chart to show summer and winter months

    Short but useless answer -- yes it is possible to create colored backgrounds. Typically they almost always involve building a combination chart (are you already familiar with building combination charts?):

    1) This one uses an XY scatter + stacked area combination chart to create a colored background for scatter chart: https://peltiertech.com/shaded-quadr...scatter-chart/
    2) This one is all stacked bar, but it puts colored vertical bands behind a Gantt like chart: https://peltiertech.com/Excel/Charts...ticalBand.html
    3) This one uses a line + column chart to highlight weekends: https://peltiertech.com/Excel/Charts...ticalBand.html

    I would guess that option 3 is going to be the easiest to adapt to your temperature vs. time chart. Have a look and let us know what parts of your chosen approach you have trouble implementing.
    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. Replies: 3
    Last Post: 01-27-2020, 12:46 PM
  2. Replies: 2
    Last Post: 09-04-2017, 11:05 AM
  3. Replies: 0
    Last Post: 02-10-2016, 06:19 AM
  4. Shaded Standard Deviation or Error Bars
    By SillayKetha in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-20-2013, 01:24 AM
  5. Replies: 2
    Last Post: 06-15-2012, 03:06 AM
  6. Shaded area representing uncertainty bars on a graph
    By alis88 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-20-2008, 06:13 AM
  7. Replies: 1
    Last Post: 02-03-2008, 10:35 AM

Tags for this Thread


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