Thread: chart Label text referencing worksheet cell value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
OTWarrior via OfficeKB.com OTWarrior via OfficeKB.com is offline
external usenet poster
  
Posts: 14
Default 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

Reply With QuoteReply With Quote