View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?