x- asis troble ( month)

[thomasleitner]

Hi,


i have a diagramm with 365 values ( one for each day 2010). i like to set the x axis to only show me the months and not all the days.


i tried changing the scale to a date axis- didnt work

i tried setting the intervall to 30 .. -> doesnt work

i tried several things on the microsoft page..


anyone that can help

 

[Luke M]

Are you using a Line Chart?

 

[thomasleitner]

a combination of a collum chart and a line

 

[Luke M]

Only the line chart will be able to be grouped into months. If you can't get to it now, I'd recommend recreating the chart by first making the line chart, changing the x-axis to months, and then creating the column part.

 

[thomasleitner]

thx.. that worked well