ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I customize data labels (https://www.excelbanter.com/charts-charting-excel/155578-how-do-i-customize-data-labels.html)

Allison

How do I customize data labels
 
I want to customize my data labels. I don't want them to be the values of the
bar graphs. I don't want to include the data that I want to be the labels
because then it will show up as bar chart.

Example I am graphing averages and I want the N to be the lables but I don't
need the N to be in a graph.

Del Cotter

How do I customize data labels
 
On Thu, 23 Aug 2007, in microsoft.public.excel.charting,
Allison said:

I want to customize my data labels. I don't want them to be the values of the
bar graphs. I don't want to include the data that I want to be the labels
because then it will show up as bar chart.


Lotus 123 had this facility going right back to the 1980s, but Excel
needs add-ins. Try one of these:

http://www.appspro.com/Utilities/ChartLabeler.htm

A dedicated chart labeler. Have labels on your bar chart, with contents
determined by some other range.

http://www.j-walk.com/ss/excel/files/charttools.htm

A larger suite of tools, that includes a chart labelling add-in.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com