How can I chart "by week"

[Guest]

Hi All,

I need to produce a line chart across three months, but show the data points
by week.

my data points each have a date attribute (ie 5/21/2006). I don't know a
smart way to do this other than making a new table (week 1, week 2, etc) and
lumping the data that way.

Thanks as Always! Kurt

 

[Guest]

Hi All,

I need to produce a line chart across three months, but show the data points
by week.

my data points each have a date attribute (ie 5/21/2006). I don't know a
smart way to do this other than making a new table (week 1, week 2, etc) and
lumping the data that way.

Thanks as Always! Kurt

Kurt,
This blood sugar chart looks like what you would like to do (my assumption)
- it is an Excel template, you can download it and replace the data with your
own.

Enjoy!
http://office.microsoft.com/en-us/templates/TC061977871033.aspx?CategoryID=CT010482871033

 

[c991257]

Hi All,

I need to produce a line chart across three months, but show the dat
points
by week.

my data points each have a date attribute (ie 5/21/2006). I don't kno
a
smart way to do this other than making a new table (week 1, week 2
etc) and
lumping the data that way.

Thanks as Always! Kurt

You can use the WEEKNUM function to convert the date to a calende
week. You would just add a column and using that as x-axis.

/Mølle

 

[c991257]

Hi All,

I need to produce a line chart across three months, but show the dat
points
by week.

my data points each have a date attribute (ie 5/21/2006). I don't kno
a
smart way to do this other than making a new table (week 1, week 2
etc) and
lumping the data that way.

Thanks as Always! Kurt

You can use the WEEKNUM function to convert the date to a calende
week. You would just add a column and using that as x-axis.

/Mølle

 

[c991257]

Hi All,

I need to produce a line chart across three months, but show the dat
points
by week.

my data points each have a date attribute (ie 5/21/2006). I don't kno
a
smart way to do this other than making a new table (week 1, week 2
etc) and
lumping the data that way.

Thanks as Always! Kurt

You can use the WEEKNUM function to convert the date to a calende
week. You would just add a column and using that as x-axis.

/Mølle

 

[c991257]

Hi All,

I need to produce a line chart across three months, but show the dat
points
by week.

my data points each have a date attribute (ie 5/21/2006). I don't kno
a
smart way to do this other than making a new table (week 1, week 2
etc) and
lumping the data that way.

Thanks as Always! Kurt

You can use the WEEKNUM function to convert the date to a calende
week. You would just add a column and using that as x-axis.

/Mølle

 

[c991257]

Hi All,

I need to produce a line chart across three months, but show the dat
points
by week.

my data points each have a date attribute (ie 5/21/2006). I don't kno
a
smart way to do this other than making a new table (week 1, week 2
etc) and
lumping the data that way.

Thanks as Always! Kurt

You can use the WEEKNUM function to convert the date to a calende
week. You would just add a column and using that as x-axis.

/Mølle

 

[c991257]

Hi All,

I need to produce a line chart across three months, but show the dat
points
by week.

my data points each have a date attribute (ie 5/21/2006). I don't kno
a
smart way to do this other than making a new table (week 1, week 2
etc) and
lumping the data that way.

Thanks as Always! Kurt

You can use the WEEKNUM function to convert the date to a calende
week. You would just add a column and using that as x-axis.

/Mølle