Chart data and axis labels

**Larph** · 08-21-2010, 07:08 AM

Hi all

I'm attempting to create that will help me to analyse business factors.

The chart format is succesful and is what I want, however it is the labeling that has thrown me for a loop.

How do I place a label on each data entry? For example, instead of the numeric value currently displayed, I owuld like to show the business factor it relates to.

Additionally, instead of -6 to +6, I would simply like to replace with Low to High.

Much appreciated!

**Andy Pope** · 08-21-2010, 08:07 AM

Use this free addin to link data labels to cells.
http://www.appspro.com/Utilities/ChartLabeler.htm

You can use and addition series with linked data labels to replace numeric axes labels with text.

**Larph** · 08-21-2010, 09:07 AM

Thanks for you kind response, Andy.

Unfortunately I can't install this Add-in for my version of Excel (2007 for mac). Back to the drawing board for me!

**Andy Pope** · 08-21-2010, 09:09 AM

Here is how to do it manually
http://www.andypope.info/tips/tip001.htm

Select the datalabels, then select specific data label before entering full cell reference.