showing start of each month as tick mark & label on X-Y chart

  • Thread starter Thread starter Bandicoot
  • Start date Start date
B

Bandicoot

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)?
 
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,
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scatter plot 1
Set position of x axis labels 2
monthly separation tick marks on x-axis 10
Position of X axis labels 4
Change Y-axis tick labels to text, possible? 1
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Formatting 'X' Axis -- 2 fundamental differences 7
X Y (Scatter) Chart EXCEL 2007 1

Back
Top