k. moran Wrote:
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
You can use the WEEKNUM function to convert the date to a calender
week. You would just add a column and using that as x-axis.
/Møller
--
c991257
------------------------------------------------------------------------
c991257's Profile:
http://www.excelforum.com/member.php...o&userid=36549
View this thread:
http://www.excelforum.com/showthread...hreadid=568040