Help with graph / chart

[S]

I have a graph for weeks 1-52, I have split this into 4 seperate graphs each
showing a quarter (13 weeks) I cant remember exactly how I created them but
possibly using some sort of copy paste as each chart show weeks 1 - 13 along
the bottom. This should read.........

for chart 1 1-13
for chart 2 14 - 26
chart 3 27 - 40
chart 4 41 - 52

How do I change this on each chart to read the week numbers indicated.?

thanks

 

[Andy Pope]

Hi,

You need to define the Category labels for the chart.
Chart 1 is fine as it defaults to the values 1 to 13.
For the other 3 charts you will need to create the span of numbers.
Simplest way is to create the values in a range of cells.

To set the range used for category labels right click the chart and pick
Source Data...
On the Series tab is a range selector for the Category labels.

Cheers
Andy

 

[S]

Thanks for your help and explanation Andy, now sorted.