Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PIE CHART EXPERT HELP REQUIRED
Hello, i'm working in Excel 2000 and I have some VBA code (taken from
http://pubs.logicalexpressions.com/P...cle.asp?ID=390) which gives a segment in a Pie Chart a colour baed on its description. Unfortunatley the suffix of the segment is always different so I would like to use a wildcard for the suffix. A typical segment description is "Personal Banking - £100k". I have tried to insert a wildcard into the code but it does not work (i.e. change the segment colour), any suggestions? 'Case "Personal Banking - *" .Points(iPoint).Interior.ColorIndex = 13 ' Purple' If I type in 'Case "Personal Banking - £100k" .Points(iPoint).Interior.ColorIndex = 13 ' Purple' it works fine but with the suffix changing as the data changes its not practical to manually adjust the code. Please help. Thanks Brian |
#2
|
|||
|
|||
Hi Brian,
You may have to use IF THEN tests rather than select. Something like this, If WorksheetFunction.Index(.XValues, iPoint) _ Like "Personal Banking - *" Then .Points(IPoint).Interior.ColorIndex = 13 ' Purple' ElseIf WorksheetFunction.Index(.XValues, iPoint) _ Like "Business Banking - *" Then .Points(IPoint).Interior.ColorIndex = 3 End If Cheers Andy Co-op Bank wrote: Hello, i'm working in Excel 2000 and I have some VBA code (taken from http://pubs.logicalexpressions.com/P...cle.asp?ID=390) which gives a segment in a Pie Chart a colour baed on its description. Unfortunatley the suffix of the segment is always different so I would like to use a wildcard for the suffix. A typical segment description is "Personal Banking - £100k". I have tried to insert a wildcard into the code but it does not work (i.e. change the segment colour), any suggestions? 'Case "Personal Banking - *" .Points(iPoint).Interior.ColorIndex = 13 ' Purple' If I type in 'Case "Personal Banking - £100k" .Points(iPoint).Interior.ColorIndex = 13 ' Purple' it works fine but with the suffix changing as the data changes its not practical to manually adjust the code. Please help. Thanks Brian -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Thats excellent, worked first time. THANKS!
"Andy Pope" wrote: Hi Brian, You may have to use IF THEN tests rather than select. Something like this, If WorksheetFunction.Index(.XValues, iPoint) _ Like "Personal Banking - *" Then .Points(IPoint).Interior.ColorIndex = 13 ' Purple' ElseIf WorksheetFunction.Index(.XValues, iPoint) _ Like "Business Banking - *" Then .Points(IPoint).Interior.ColorIndex = 3 End If Cheers Andy Co-op Bank wrote: Hello, i'm working in Excel 2000 and I have some VBA code (taken from http://pubs.logicalexpressions.com/P...cle.asp?ID=390) which gives a segment in a Pie Chart a colour baed on its description. Unfortunatley the suffix of the segment is always different so I would like to use a wildcard for the suffix. A typical segment description is "Personal Banking - £100k". I have tried to insert a wildcard into the code but it does not work (i.e. change the segment colour), any suggestions? 'Case "Personal Banking - *" .Points(iPoint).Interior.ColorIndex = 13 ' Purple' If I type in 'Case "Personal Banking - £100k" .Points(iPoint).Interior.ColorIndex = 13 ' Purple' it works fine but with the suffix changing as the data changes its not practical to manually adjust the code. Please help. Thanks Brian -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timeline Chart? | Charts and Charting in Excel | |||
Chart formatting | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
Impedding/Overlaying Charts | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |