Forum Discussion
cameronclimbs247
May 26, 2022Copper 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 exa...
- May 26, 2022
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]
PeterBartholomew1
May 26, 2022Silver Contributor
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]
- cameronclimbs247May 27, 2022Copper Contributor
PeterBartholomew1 Yes this works perfect! Thank you Peter. I poked around with combo charts and figured out something similar.