Chart Colours
I have a chart this is based on a Pivot Table. I go into the chart and
change the colours into something a bit brighter than the standatrd coulour, but when I change the view ot the chart (i.e. from show all to just one piece of data) when the chart refreshes the coulours go back to their original values. How can I make the colour changes I make stay when the chart is refreshed? |
Chart Colours
This is a known bug that required vba code to re-apply formatting.
XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 Cheers Andy Keith wrote: I have a chart this is based on a Pivot Table. I go into the chart and change the colours into something a bit brighter than the standatrd coulour, but when I change the view ot the chart (i.e. from show all to just one piece of data) when the chart refreshes the coulours go back to their original values. How can I make the colour changes I make stay when the chart is refreshed? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
All times are GMT +1. The time now is 11:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com