4
votes

Using a Column chart. My Category groups are Month and Year, with Month being the inner group so that a three-letter abbreviation of the month is shown directly under the data column and the Year is beneath that set of months. However, the data columns start at a position on the left of the month tick mark (for the first month displayed) and gradually moves to the right of the month tick mark for the last month displayed.

So, how does one set the column to be directly centered on the Month tick mark?

Here is an image of what i have now:Column Chart

Thanks!

1
Did you ever figure this out? Struggling to find an answerJeremyBeadle
Here's the same issue on the graph I have i.imgur.com/cYHVg.pngJeremyBeadle
Also, the wider I set the width of the column, the further away from the central point it appearsJeremyBeadle

1 Answers

3
votes

The Problem is in Design of the chart. Please know about the series Groups and category groups.

Please check that the Category Groups and Series Groups of the chart. The Series Group should not contain the month name and in the category Groups use the month Name field inside the Year field.

Hope this will help. Attached the Images.

Before Modification enter image description here After Modification enter image description here