Home

Clustered column tick mark issue

%3CLINGO-SUB%20id%3D%22lingo-sub-740807%22%20slang%3D%22en-US%22%3EClustered%20column%20tick%20mark%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740807%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20having%20an%20issue%20where%20the%20first%20and%20last%20columns%20on%20a%20clustered%20column%20chart%20disappear%20when%20I%20switch%20between%20tick%20mark%20modes%20on%20the%20horizontal%20axis.%20Also%20the%20axis%20labels%20do%20no%20line%20up%20correctly.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122418i9DF244C9D22803CD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22On%20Ticks.JPG%22%20title%3D%22On%20Ticks.JPG%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F122419iE634CD87C5092DBD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22between.JPG%22%20title%3D%22between.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-740807%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-740928%22%20slang%3D%22en-US%22%3ERe%3A%20Clustered%20column%20tick%20mark%20issue%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-740928%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F371992%22%20target%3D%22_blank%22%3E%40glegar25%3C%2FA%3E%26nbsp%3BIt%20looks%20like%20you%20have%2011%20data%20series%20in%20your%20graph%20instead%20of%20one%20data%20series.%20Excel%20is%20creating%20space%20for%20all%20eleven%20columns%20above%20each%20label%20even%20though%20only%20one%20column%20is%20shown.%20The%20reason%20the%20category%20labels%20are%20not%20aligned%20is%20that%20the%20horizontal%20position%20of%20the%20shown%20column%20changes%20due%20to%20the%20number%20of%20missing%20columns%20on%20each%20side%20of%20the%20one%20shown.%20The%20first%20column%20is%20to%20the%20left%20of%20the%20%221%22%20label%20and%20the%20last%20column%20is%20to%20the%20right%20of%20the%20%2211%22%20label.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20reason%20the%20first%20and%20last%20columns%20disappear%20is%20that%20when%20you%20use%20the%20%22on%20tick%20marks%22%20option%20Excel%20aligns%20the%20label%20to%20the%20tick%20marks%2C%20which%20are%20in%20the%20middle%20of%20the%20space%20used%20for%20each%20category.%20Since%20the%20first%20column%20is%20so%20far%20to%20the%20left%20of%20the%20label%2C%20it%20gets%20cut%20off.%20Same%20for%20the%20last%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20solution%20is%20to%20arrange%20your%20data%20so%20that%20you%20have%20one%20data%20series%20instead%20of%2011.%20Then%20the%20labels%20will%20be%20under%20the%20center%20of%20each%20column.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I'm having an issue where the first and last columns on a clustered column chart disappear when I switch between tick mark modes on the horizontal axis. Also the axis labels do no line up correctly.

On Ticks.JPGbetween.JPG

1 Reply
Highlighted

@glegar25 It looks like you have 11 data series in your graph instead of one data series. Excel is creating space for all eleven columns above each label even though only one column is shown. The reason the category labels are not aligned is that the horizontal position of the shown column changes due to the number of missing columns on each side of the one shown. The first column is to the left of the "1" label and the last column is to the right of the "11" label.

 

The reason the first and last columns disappear is that when you use the "on tick marks" option Excel aligns the label to the tick marks, which are in the middle of the space used for each category. Since the first column is so far to the left of the label, it gets cut off. Same for the last column.

 

The solution is to arrange your data so that you have one data series instead of 11. Then the labels will be under the center of each column.

Related Conversations
Bug - owner can't manage tags
Konrad92 in Microsoft Teams on
0 Replies
Edge Canary Version 82.0.456.0 Collection
HotCakeX in Discussions on
0 Replies
What does backed off status mean in Edge sync?
HotCakeX in Discussions on
0 Replies
Cannot access Microsoft Teams
rmendozamz in Microsoft Teams on
1 Replies