Individually Formatted Category Axis Labels
by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2009.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
A reader named Roland asks, “How can I individually format the labels on my category axis?”

Excel axis tick labels cannot be individually formatted. But you can make a chart like thee above in Excel. You simply need to use a little trick involving a second hidden series and its data labels.
First, add a column to the data range that contains all zeros.
| Data | Labels | |
| red small | 5 | 0 |
| italic | 7 | 0 |
| blue big | 8 | 0 |
| bold | 6 | 0 |
Select this entire range and create the column chart.

Format the category axis to hide its default category labels.

Convert the “Labels” series to a line type. To select this series, select the “Data” series and click the up arrow key. To change the type, right click on it and select Chart Type or Change Chart Type, or go to the Chart menu or Chart Tools Design tab and select Chart Type or Change Chart Type.

Format the “Labels” series so it has no line and no markers. Also apply data labels to the “Labels” series using the Category option.

Format the data labels so they are in the Below position.

Format the data labels individually. To select a single data label: click once to select the series of labels, then click again on the specific label.

Possibly Related Posts:
- Individually Formatted Dual Category Labels
- Callout Labels with XY Line Segments
- Category Labels That Don’t Overlap the Data
- Magazine Quality Chart (Economist)
- Candlestick Alternative: Individually Colored Up-Down Bars
- Clustered-Stacked-Column Combo Chart With Lines
- How to Build a Simple Panel Chart
- Draw an Axis With Tick Marks But No Line
- US Employment Slump Chart - How To
- Integer Values on Line Chart Category Axis
Posted: Saturday, May 24th, 2008 under Chart Axes.
Comments: 1
Comments
Comment from fulvioo
Time: Saturday, May 24, 2008, 4:56 pm
Nice trick.
Your blog rocks, thank you for constantly update it with useful information.























Write a comment
I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.
If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.
Read the PTS Blog Comment Policy.