X axis step in Bar Chart

[#1]

Hi All,

I have a bar chart with sales on y axis and month-year(Jan 2013, Feb 2013 etc) on x axis. I want to show axis labels for every 6 months instead of every month such as Jan 2013, June 2013 etc. How do I do this? Also, how can I show the x axis labels slant instead of horizontal. Thanks in advance for helping out.

[Gysbert_Wassenaar]

You can try setting the Dimension Axis to Continuous with 181 as Static Step value. Next on the Number tab select the Continuous X-axis and choose Date under Number Format Settings and use MMM YYYY as format string.

For slanted text you can select the middle radio button for the Primary Dimension labels (just below the '/' symbol ).

[#3]

Thanks Gysbert, when I select the continuous option, it is complaining "no numeric data on x axis". Can you please advise?

[Gysbert_Wassenaar]

Ah, your months are strings, not dates formatted as months. Try creating dates from the strings in the script first:

date(date#(MyMonthField, 'MMM YYYY'), 'MMM YYYY') as MyMonthField

[#5]

Sorry I accidentally marked it a answer, I have 3 fields in my data set. Reporting Date, Reporting Month(numeric), Reporting Month(text), Reporting Year. I am using Reporting Month(text) and Year to show in the axis in my Chart. What expression should I use? Thanks again!!

[#6]

I used the expression =date(ReportingDate, 'MMM YY') but it is showing numerous bars in the chart. I only have 3 years worth of data so I should'be be seeing more than 36 bars. Any thoughts?

[Gysbert_Wassenaar · Accepted solution]

Try =date(monthstart(ReportingDate), 'MMM YY')