X Axis labels as month

[Expiry]

I have a simple chart which I'm plotting daily values on. I don't want daily labels on the x-axis, though.

I'd like to have it say Mar, Apr etc. Only once, neatly in the middle of the 30/31 entries for the month.

Is there a way of doing that within the formatting of the chart?

 

[RoryA]

If it's a timescale axis, set the min to be the middle of the month before your data starts, set the major unit to be one month and use a "mmm" number format.

 

[Expiry]

That works - almost. My dataset starts on 1st March, so I've set my min to 15th Feb. I now have a blank section of the chart for Feb, to the left of the Y axis, which I don't want.

 

[RoryA]

C'est la vie. You cannot, AFAIK, have everything

 

[Rasm]

Lol

 

[Gerald Higgins]

You could also use a helper column to show the month, once a month, and use that column to drive your x axis labels.

For example, let's say your daily dates are in the range A1:A365.
In the helper column, put

=IF(DAY(A1)=15,A1,"")

and format as mmm (or mmmm if you prefer).
Using 15 will put the label roughly in the middle of the month.
Change 15 to some other number if you want to position the label somewhere else.
Copy down as far as required.
Use this helper column as the source for the x axis labels.
Remember to go into Format Axis, Scale, set "Number of Categories between x axis labels" to 1.

 

[Rasm]

I just posted code for similar chart - well it has an axis like you are asking for. I use arrays - but you can input a range instead - same diff

see post - (was posted today)

Re: Tricky Graph question

 

[Rasm]

You can only do this for line charts - I got this cool link form somebody here - it explains charts very well

http://pubs.logicalexpressions.com/pub0009/LPMArticle.asp?ID=190