May 26 2022 11:54 AM
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
May 26 2022 02:54 PM
Solution@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]
May 26 2022 05:45 PM
@Peter Bartholomew Yes this works perfect! Thank you Peter. I poked around with combo charts and figured out something similar.
May 26 2022 05:48 PM
May 27 2022 04:00 AM
That is a question about a completely different subject. Please start a new discussion and ask your question there.
May 26 2022 02:54 PM
Solution@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]