Thread: Charting with weeknumbers over two years

Hi all,
I am having a problem with a chart. I have a column with Year (2008-2009) which is not used in the chart and a column called Weeknumber (1-52 (for both 2008 and 2009)) and finally a column with values. I am trying to do a chart with this and 2008 works fine shows all values from 1 to 52, but when I put in year 2009 ie week 1 to 27 the scale does not accept that and just scales upwards from 52 to 79 how can I fool excel to accept that it puts out 1 to 27 for year 2009 (instead of 52 - 79)??
Xlbob

depends what type of chart you are using and how you data is set up

can you post example workbook

The problem was both columns of information were plotted as a series.

What you actually needed was the first series to be used as category labels and the second as the data.

Simplest way would have been to remove the header above the category labels.

I have also changed the data so it's possible to get the year information included in group.

double click X axis.
Scale tab > Number of categories between tick mark labels.

I see, when you use the multi level category labels ALL labels are displayed.

If you want only some of the labels AND multi levels you will have to remove the unwanted values from the range.