Thread: showing start of each month as tick mark & label on X-Y chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Bandicoot Bandicoot is offline
external usenet poster
  
Posts: 4
Default 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)?
Reply With QuoteReply With Quote