chart Label text referencing worksheet cell value
 

I have a very simple bar chart that I want to display the values and the
percentages of those values.

For some reason, the percentage option is disabled under chart options, so i
thought I would use a label instead, and send the calculation to it so it is
dynamic. Sounds simple right?

Wrong!

I can only pass raw text into the label:

Selection.Characters.Text = "100%"

the following does not work, and the label disappears:
.Selection.Characters.Text = Sheets("tbl_Voids").Range("A6794").Value

is there a way of doing this?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200707/1

chart Label text referencing worksheet cell value
 

Check out Rob Bovey's Chart Labeler at http://appspro.com.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"OTWarrior via OfficeKB.com" <u33269@uwe wrote in message
news:751d5c365ae10@uwe...
I have a very simple bar chart that I want to display the values and the
percentages of those values.

For some reason, the percentage option is disabled under chart options, so
i
thought I would use a label instead, and send the calculation to it so it
is
dynamic. Sounds simple right?

Wrong!

I can only pass raw text into the label:

Selection.Characters.Text = "100%"

the following does not work, and the label disappears:
Selection.Characters.Text = Sheets("tbl_Voids").Range("A6794").Value

is there a way of doing this?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...chart/200707/1