Hi,
I am making a chart that is grouping data by week with the weeks being the labels on the X axis. I have tried it as both a pivot chart and a chart wizard onto a form. Currently the labels look like, 47 '10, 48 '10, 49'10, etc. This doesn't really work that well for the people that will be using the database. There are a couple of different ways that would make it better, but I don't know how to do them.
Can the labels somehow be changed to the week ending date?
Can the calender be changed from a normal calender to a custom calender? As in, can the 1st week of 2010 be considered November 1 - 7.
Thanks
I am making a chart that is grouping data by week with the weeks being the labels on the X axis. I have tried it as both a pivot chart and a chart wizard onto a form. Currently the labels look like, 47 '10, 48 '10, 49'10, etc. This doesn't really work that well for the people that will be using the database. There are a couple of different ways that would make it better, but I don't know how to do them.
Can the labels somehow be changed to the week ending date?
Can the calender be changed from a normal calender to a custom calender? As in, can the 1st week of 2010 be considered November 1 - 7.
Thanks
