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

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?

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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"L-Man" wrote in message
...
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?