SOLVED

New Contributor

# 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.

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

Kind regards,
Cameron

4 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

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

@cameronclimbs247 Something like this perhaps?  The value series in a line chart but the season has been represented by a column chart against the secondary axis.  Values are 1-10 whereas the season axis is against a scale 0-1 [0-MAX(value) would be another option if the data series used that range]

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

@Peter Bartholomew Yes this works perfect! Thank you Peter. I poked around with combo charts and figured out something similar.

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

hola chicos queria que me ayuden necesito sumar dos valores y restar el tercero como puedo hacerlo

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

That is a question about a completely different subject. Please start a new discussion and ask your question there.