Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I'm plotting a number of data series on an x-y scatter chart. Values are
recorded daily over an 18 month period and are plotted against time on the x-axis. To make the graph look neat I want to place tick marks at monthly intervals at the first of each month. Because the number of days in the month varies it is not possible to select an appropriate major unit in the format axis box. As a result, if I select for example 31 as the major unit then the monthly tick marks progressively move to a later date in the month - starting from 01 August 05 and by March 07 my tick mark is placed at the 13th. Is there anyway to overcome this? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Placement of tick marks | Charts and Charting in Excel | |||
x axis tick marks | Charts and Charting in Excel | |||
Tick marks | New Users to Excel | |||
Y-axis tick marks in middle of chart? | Charts and Charting in Excel | |||
Need specific tick marks on Y axis | Charts and Charting in Excel |