About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store



Past Tip of the Day


Cathy writes" I created a column chart in Excel. There are 5 data points, and the text is appearing along the x-axis for columns 1, 3 and 5, but it is missing for columns 2 and 4. I checked the worksheet, and the text is appearing in the table. Why isn't it appearing in the chart?

If you create a chart in a worksheet, you may find that Excel sets this option by default. You may find that you don't like some of the chart options set by Excel. The great news is that everything in a chart is customizable. All of those settings are just a right-click away.

In this case, go to the X axis and right click the words for the first data point. From the pop-up menu, select Format axis. There are five tabs across the Format Axis dialog. This particular setting is on the Scale tab. On the Scale tab, change the value for "Number of Categories between Tick Mark Labels from 2 to 1.

By Bill Jelen on 17-Nov-2001 Consulting can be hired to implement this concept, or many other cool applications, with your data. provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.


Excel is a registered trademark of the Microsoft® Corporation.

All contents Copyright 1998-2008 by MrExcel Consulting.