| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How can I chart "by week"
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I chart "by week"
"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 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/te...CT010482871033 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I chart "by week"
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I chart "by week"
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 |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I chart "by week"
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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I chart "by week"
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 |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I chart "by week"
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 |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How can I chart "by week"
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting values in a bar chart | Charts and Charting in Excel | |||
| Activating a Chart object | Charts and Charting in Excel | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Linear Mode
