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
glegar25
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

@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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies