data labels

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geebee - 24 Jul 2007 14:14 GMT

i have a spreadsheet that contains a bar graph based on 2 columns. basically
the graph compares goals to actuals. the challenge here lies in the desire
to add in the the data labels, which are based on the 4th column of data.
right now, i have text boxes showing these percentage values. how can i do
this more effificiently and have the graph bar labels based on a column?

Reply to this Message

Andy Pope - 24 Jul 2007 14:43 GMT

Hi,

Check the free addin on Rob's page, which helps you link data labels to
cell.
http://www.appspro.com/Utilities/ChartLabeler.htm

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>i have a spreadsheet that contains a bar graph based on 2 columns.
>basically
[quoted text clipped - 4 lines]
> do
> this more effificiently and have the graph bar labels based on a column?

Reply to this Message

Del Cotter - 24 Jul 2007 14:46 GMT

>i have a spreadsheet that contains a bar graph based on 2 columns. basically
>the graph compares goals to actuals. the challenge here lies in the desire
>to add in the the data labels, which are based on the 4th column of data.
>right now, i have text boxes showing these percentage values. how can i do
>this more effificiently and have the graph bar labels based on a column?

Rob Bovey has a very good add-in to provide this missing capability to
Excel:

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

There is also a data label utility as part of John Walkenbach's Chart
Tools add-in:

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

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

geebee - 24 Jul 2007 15:08 GMT

hi,

This add in seems really cool. but what if the company policy prevents the
use of add ins? is there a different type of graph that i could use? i am
just trying to get the prcentage of the goal versus actual to be used as the
data label. the percentage and goal is shown next to each other for each
reguinal center.

thanks in advance,
geebee

> >i have a spreadsheet that contains a bar graph based on 2 columns. basically
> >the graph compares goals to actuals. the challenge here lies in the desire
[quoted text clipped - 11 lines]
>
> http://j-walk.com/ss/excel/files/charttools.htm

Reply to this Message

Andy Pope - 24 Jul 2007 15:32 GMT

The addin just makes the linking of data labels to cells very easy.

But you can do it manually. This pages explains how to do it for the chart
title but the principle can be applied to individual data labels.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

> hi,
>
[quoted text clipped - 28 lines]
>>
>> http://j-walk.com/ss/excel/files/charttools.htm

Reply to this Message