Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time Scale for Charts
In the 2003 Version of Excel I was able to set time scales with a Min Date
and Max Date - for example: 1/1/2008 - 12/31/2008. I have charts that measure the Call volumes in our area per month and I am unable to see each month on the Horizontal Axis. Thanks, Susie |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time Scale for Charts
You can set the min and max the same way, if you've made a line chart with a
date axis. The particulars of how the controls are laid out in the dialog are somewhat different, but you should be able to find them. What I like to do is set the base unit to days, and the major unit to months, typically 1 month. If I start on 1/1/2008 and end on 1/1/2009, I get a tick mark and label on the first of each month. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Susie" wrote in message ... In the 2003 Version of Excel I was able to set time scales with a Min Date and Max Date - for example: 1/1/2008 - 12/31/2008. I have charts that measure the Call volumes in our area per month and I am unable to see each month on the Horizontal Axis. Thanks, Susie |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Time Scale for Charts
A week is seven days, right? Format the axis scale so the min is 8/15 and
the major unit is 7 days. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "dartmoor" wrote in message ... Okay - so i want to set weekly dates at 7 day intervals starting Aug 15. My vertical axis records numbers at weekly intervals (every Saturday). How do i get the X axis to reflect weekly ticks Aug 15, Aug 22 etc so I can monitor the changes? tim k -- "Jon Peltier" wrote: You can set the min and max the same way, if you've made a line chart with a date axis. The particulars of how the controls are laid out in the dialog are somewhat different, but you should be able to find them. What I like to do is set the base unit to days, and the major unit to months, typically 1 month. If I start on 1/1/2008 and end on 1/1/2009, I get a tick mark and label on the first of each month. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Susie" wrote in message ... In the 2003 Version of Excel I was able to set time scales with a Min Date and Max Date - for example: 1/1/2008 - 12/31/2008. I have charts that measure the Call volumes in our area per month and I am unable to see each month on the Horizontal Axis. Thanks, Susie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetic scale in charts | Charts and Charting in Excel | |||
Can I make gray scale charts? | New Users to Excel | |||
Colors/Scale in Radar Charts | Charts and Charting in Excel | |||
How to correctly scale X-Axis in Charts? | Excel Discussion (Misc queries) | |||
Printing charts to scale | Charts and Charting in Excel |