Hi, I want to show 100% columns to show trends over time, but at the moment, the chart looks very confusing (see screenshot). Can anyone help me group the years together within each Column header (Lowest, Low, Average, High, Highest), in order to make the graph easier read? Or does anyone have any other ways to show this kind of 'trends over time within sub-groups' in a clearer way using excel?
TIA for any help you can offer!
Excel support.jpg
Bookmarks