Prev: Calclulating percentages
Next: Shape Range
From: Sucram on 21 Apr 2010 10:38
Excel 2007

My horizontal axis is made up of the week number values for the year week 1
to week 53.

I have two sets of data to plot as bars against thos axis.

The first set is data from 2009 and the second set is the data collected so
far from 2010.

My problem is that the 2009 data started being collected from week 8
however, when plotted in my chart is starts from week 1.

The data range I'm selcting uses a common week row for its values with the
two sets of data (2009 & 2010) contained in rows underneath.

Any ideas?


From: Karissa on 22 Apr 2010 13:11
It sounds as though you haven't included any blank spaces for sourcing your
data for 2009. Make sure that you have weeks 1-53 selected for 2009, even
though 1-7 will be blank. Consider them spacers. I hope this helps.

"Sucram" wrote:

> Excel 2007
>
> My horizontal axis is made up of the week number values for the year week 1
> to week 53.
>
> I have two sets of data to plot as bars against thos axis.
>
> The first set is data from 2009 and the second set is the data collected so
> far from 2010.
>
> My problem is that the 2009 data started being collected from week 8
> however, when plotted in my chart is starts from week 1.
>
> The data range I'm selcting uses a common week row for its values with the
> two sets of data (2009 & 2010) contained in rows underneath.
>
> Any ideas?
>
>
 | 
Pages: 1
Prev: Calclulating percentages
Next: Shape Range