Hello,
Hoping someone may be able to help me with a charting query I have. I will be quite specific with the data labels I am using as I think it will help illustrate my issue.
I have several locations and for each location I have 4 years of total yearly water consumption and a related KPI measure.
I want my chart to show by location the yearly water consumption for the 4 years in a bar chart (primary y axis) and the related KPI measure for each location as a line chart (secondary y axis). I want the locations to appear on the graph as quite discrete.
I can't seem to work out how to do this as I have been unable to separately group the KPI information per location and then apply the secondary axis option. When I apply secondary axis and line chart format it joins the KPI information across all the locations.
I have attached a file which shows a sample of the data and the chart generated.
Any assistance would be very appreciated.
Thanks