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?

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
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"geebee" (noSPAMs) wrote in message
...
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?

On Tue, 24 Jul 2007, in microsoft.public.excel.charting,
geebee said:

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

--
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.

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

"Del Cotter" wrote:

On Tue, 24 Jul 2007, in microsoft.public.excel.charting,
geebee said:

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

--
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.

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"geebee" (noSPAMs) wrote in message
...
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

"Del Cotter" wrote:

On Tue, 24 Jul 2007, in microsoft.public.excel.charting,
geebee said:

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

--
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.