Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
Display "this week" column headers w/date & day of week? | Excel Worksheet Functions | |||
How can I chart "by week" | Charts and Charting in Excel |