Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
showing start of each month as tick mark & label on X-Y chart
Using Excel 2007
I am plotting information (Y axis) versus dates (X axis) using an X-Y scatter chart. Is there any way to show "1 Jan", "1 Feb" etc on the X axis as the tick marks and labels, rather than some integer interval of days that results in "1 Jan" then "30 Jan" then "2 Mar" (or whatever)? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
showing start of each month as tick mark & label on X-Y chart
On Wed, 20 Feb 2008, in microsoft.public.excel.charting,
Bandicoot said: I am plotting information (Y axis) versus dates (X axis) using an X-Y scatter chart. Is there any way to show "1 Jan", "1 Feb" etc on the X axis as the tick marks and labels, Use a Line Chart instead of a scatter, and if the x axis does not automatically select Time-scale, then got to Chart Options.. Axes.. X axis.. and choose Time-scale. Then in Format Axis.. Scale, you can set the scale to calendar months. That's how it works before 2007 anyway. You need to find the equivalent menu options for 2007. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
X axis tick mark over label | Charts and Charting in Excel | |||
Tick Mark Label Line Wrap | Charts and Charting in Excel | |||
Column chart - category axis - make to start with the second label | Excel Discussion (Misc queries) | |||
How do I justify/align tick mark labels on a horizontal bar chart? | Charts and Charting in Excel | |||
Scatter chart x axis tick mark lables | Charts and Charting in Excel |