Add shaded bars to seasonal chart to show summer and winter months
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.
Last edited by cameronclimbs247; 05-26-2022 at 02:47 PM.
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.
Originally Posted by shg
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By Sophie200 in forum Excel Charting & Pivots
Last Post: 01-27-2020, 12:46 PM
By Actuary07 in forum Excel Charting & Pivots
Last Post: 09-04-2017, 11:05 AM
By kami66 in forum Excel General
Last Post: 02-10-2016, 06:19 AM
By SillayKetha in forum Excel Charting & Pivots
Last Post: 03-20-2013, 01:24 AM
By smotty in forum Excel Charting & Pivots
Last Post: 06-15-2012, 03:06 AM
By alis88 in forum Excel Charting & Pivots
Last Post: 10-20-2008, 06:13 AM
By toplisek in forum Excel General
Last Post: 02-03-2008, 10:35 AM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1