| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart with filterable legend
I have a chart that has a few items in the legend. Is it possible to have the pull down legend like a PivotChart has? I cannot use an actual PivotChart for this report because of the way the data is calculated. Is it possible to enable an option in VBA? Any help would be great. Thanks. -- stuartmarsh ------------------------------------------------------------------------ stuartmarsh's Profile: http://www.excelforum.com/member.php...o&userid=22142 View this thread: http://www.excelforum.com/showthread...hreadid=570678 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart with filterable legend
Hi,
Have a look at this. http://peltiertech.com/Excel/Charts/ChartByControl.html Cheers Andy stuartmarsh wrote: I have a chart that has a few items in the legend. Is it possible to have the pull down legend like a PivotChart has? I cannot use an actual PivotChart for this report because of the way the data is calculated. Is it possible to enable an option in VBA? Any help would be great. Thanks. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Chart with filterable legend
Thanks this looks promising. -- stuartmarsh ------------------------------------------------------------------------ stuartmarsh's Profile: http://www.excelforum.com/member.php...o&userid=22142 View this thread: http://www.excelforum.com/showthread...hreadid=570678 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart Legend | Charts and Charting in Excel | |||
| Legend disappears from chart. | Charts and Charting in Excel | |||
| Hide series names for unused data from chart legend | Charts and Charting in Excel | |||
| Chart Legend Entries | Excel Discussion (Misc queries) | |||
| Stack Chart Legend Display | Charts and Charting in Excel | |||
Linear Mode
