Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text label in x-axis (scatter chart) | Charts and Charting in Excel | |||
How change dimensions of data label text box in pie chart? | Charts and Charting in Excel | |||
Text is missing along the vertical axis of the chart (Y label). | Charts and Charting in Excel | |||
Adding a certain text label in a excel chart | Charts and Charting in Excel | |||
Referencing worksheet CODENAME in a chart object. | Excel Discussion (Misc queries) |