Peltier Tech Blog

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

 

Main menu:

 
Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 
Excel Dashboards

Subscribe

Site search

Subscribe

Site search


Recent Posts

Recently Commented

Popular Posts

Archive


 

Categories


 

Privacy Policy

Creative Commons License
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.

Individually Formatted Category Axis Labels

by Jon Peltier
Saturday, May 24th, 2008
Peltier Technical Services, Inc., Copyright © 2010.
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.

Related Posts:

Bookmark and share this entry:
  • Twitter
  • Digg
  • Facebook
  • LinkedIn
  • del.icio.us
  • Technorati
  • StumbleUpon
  • Google Bookmarks
  • Reddit
  • MySpace
  • Slashdot
  • Yahoo! Buzz
  • Tumblr

Learn how to create Excel dashboards.

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.


Comment from Audrey
Time: Monday, January 25, 2010, 11:08 am

Wow, ingenious!


Comment from Syed Altaf
Time: Thursday, June 24, 2010, 3:00 am

Thanks for your Quick Reply. . .This what I was looking for .. .:-) But I am stuck in middle could u please guide me how to “Format the category axis to hide its default category labels”. I am using Excel 2007.

Thank you so much. . and yes the Blog is Outstanding!!


Comment from Jon Peltier
Time: Thursday, June 24, 2010, 9:15 am

Syed -

Right click on the axis, choose Format Axis from the pop up menu, and on the main screen of the dialog, find the option for where to show the labels. Options are High (top of chart), Low (bottom of chart), Next to Axis, and None. Choose None to hide the labels.


Comment from Syed Altaf
Time: Friday, June 25, 2010, 2:22 am

Wow. .Thank you So much Jon . . .It helped me a lot. . I will try it for multiple axis chart. .with huge data. . .Thanks a ton .. .

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.





Subscribe without commenting

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.