Help with graph / chart

S

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
 
A

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top