Excel 2007 - no "week" period available for chart formatting

[L-Man]

In 2003 I could use a weekly bucket "monday of each week" as an axis data
point. In 2007 there is only days, months or year. I can't get days to
work, even if I select "7" days, because it doesn't allow me to format the
chart correctly like 2003. This is critical to managing several of my small
manufacturing businesses.

Does anyone know of an answer or work around?

 

[Jon Peltier]

Charts don't have a 'week' option for base unit, not in 2007 and not in
earlier versions. You may have done some similar grouping in a pivot table
or elsewhere in the worksheet. But not in a chart.

If your worksheet had data only on Mondays, you can override the default
date-scale axis in either version of Excel. In 2007 right click on the Axis,
choose Format XXX, then on the main screen of the dialog, change Date Axis
(or Automatic) to Text Axis. In 2007, go to Chart menu > Chart Options >
Axes tab, and change the Category Axis selection from Time-Scale (or
Automatic) to Category.

- Jon