chart Label text referencing worksheet cell value

  • Thread starter OTWarrior via OfficeKB.com
  • Start date
O

OTWarrior via OfficeKB.com

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding a single label on excel chart 2
Excel Changing chart label colors based on a value in a cell 0
data label disappears when I move it 0
Do not display Value label if value = zero 1
Label a Percentage Bar with Value 3
Stack Chart Help 1
Angling Label Text on a Chart 2
I can't get the percentages to work in a bar chart data label. 1

Top