Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve Text of Data Point
I have a set of charts which display a percentage in a pie chart.
On certain charts I would like to be able to control the color of a pie slice based on what the item's name is. For instance, if I have 3 charts that all list a status and an associated count then I would want "Status A" to be Red in all charts, "Status B" to be Blue in all charts, etc. I know I can change the color of the data label using the Interior object, but how do I know which Point is associated with which Status? The text of the Data Lable is a percentage, so that is of no direct, reliable help. Any suggestions for matching up Points in a Series to the actual data? Thanks! jc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I link a text box on a chart to a specific data point? | Charts and Charting in Excel | |||
Retrieve text from filter data in workbook 1 and place values in 2 | Excel Discussion (Misc queries) | |||
Can I fix a text box to a chart data point? | Charts and Charting in Excel | |||
Data point on line is not over the point/tick in X axis... | Charts and Charting in Excel | |||
Retrieve point address from scatter plot by clicking? | Charts and Charting in Excel |