0
votes

In X axis of a column Chart I have a Year (for ex, "2009") and Month (for ex, "Jan") category groupings, and I would like to show just the first month of every quarter like Jan, Apr, Jul, Oct, etc. When I specified the Interval = 3 it gives me Mar , Jun, Sep, Dec… How can one set it so it returns the first value?

1

1 Answers

1
votes

Contacted MS support and was given a solution, rather simple...I just had to set the following properties (using the properties windows not the chart UI ) for the Chart Axis:

Interval:3 Internal Offset:1 (this one is not present in the Axis UI just the properties window....:-s) Margins:1