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