Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

Changing range of data labels in chart

Posted by Jon on March 20, 2001 8:43 PM

Anyone know how to change the range for data labels in an Excel chart? I would like to label my points with something besides the value being plotted.

Any suggestions are appreciated!

Jon

Re: Changing range of data labels in chart

Posted by Mark on March 21, 2001 9:59 AM

Re: Changing range of data labels in chart

Posted by Mark on March 21, 2001 10:04 AM

Try-

right click on chart to get context menu
select 'Source Data...'
click on the 'Series' tab
at the bottom of the 'Series' tab there will be an range selection box labeled 'Category (X) axis labels' where you can select the range

HTH

Re: Changing range of data labels in chart

Posted by Jon on March 21, 2001 5:27 PM

Tried that - in my Seried tab there is no option to define a range for labels...I thought it would have been there, but its not.

JDB

Series tab does not have box to specify label range.

Posted by Jon on March 25, 2001 4:07 PM

I checked that, but under my Sseries tab there is no option to specify Range for data labels.....

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.