I have a chart which represents the values for the last 3 months for a range of locations. The location name is in column 1, the values change from month to month by 1 column right. I use
to establish the X and Y values, but the chart appears either with all months or, if I leave the Location out, offers the column next to the first month's data as X values.
I have got round this for the moment by
an appropriate number of times, but this can't be good.
Can somebody suggest a solution?