| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Month start placement on axes
I have a formatted chart in excel and the major tick marks and month data is
showing in the actual middle of the month. How do I make the tick label and mark show at the beginning of the actual month? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Month start placement on axes
Presumably you have a date-scale axis, with the base unit in months. Double
click the axis, change Base Unit to Days, change Major Unit to 1 Month, and change the Minimum to the first of a month. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jo" wrote in message ... I have a formatted chart in excel and the major tick marks and month data is showing in the actual middle of the month. How do I make the tick label and mark show at the beginning of the actual month? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Month start placement on axes
Hi Jon
Thanks for getting back to me. I have it set to a custom date of mmm-yy so don't have an option to change to days when I click on the axis. "Jon Peltier" wrote: Presumably you have a date-scale axis, with the base unit in months. Double click the axis, change Base Unit to Days, change Major Unit to 1 Month, and change the Minimum to the first of a month. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jo" wrote in message ... I have a formatted chart in excel and the major tick marks and month data is showing in the actual middle of the month. How do I make the tick label and mark show at the beginning of the actual month? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Month start placement on axes
Format will not affect your scale options. Double click on the axis, and
click on the Scale tab. Right below the tab label, doe it say "Time (X) Axis Scale" or "Category (X) Axis Scale"? If it says category, go to Chart menu Chart Options Axes tab, and check Time-Scale under Category (X) Axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jo" wrote in message ... Hi Jon Thanks for getting back to me. I have it set to a custom date of mmm-yy so don't have an option to change to days when I click on the axis. "Jon Peltier" wrote: Presumably you have a date-scale axis, with the base unit in months. Double click the axis, change Base Unit to Days, change Major Unit to 1 Month, and change the Minimum to the first of a month. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jo" wrote in message ... I have a formatted chart in excel and the major tick marks and month data is showing in the actual middle of the month. How do I make the tick label and mark show at the beginning of the actual month? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List of dates for month from start date | Excel Discussion (Misc queries) | |||
| Adjusting the y axes on 2-axes line graphs | Charts and Charting in Excel | |||
| OT :Start your own online business today !start making dollars | Excel Discussion (Misc queries) | |||
| Create a custom chart, two stacked bars/month w/ two axes? | Charts and Charting in Excel | |||
| Generating a blank worksheet at the start of the month | New Users to Excel | |||
Linear Mode
