I want to maintain my selected color for the pivot chart. But, when i filter
the chart, the selected color will refresh back to default color.
Any idea to keep my selected color for the pivot chart even i refresh the
chart?
Thanks.
I want to maintain my selected color for the pivot chart. But, when i filter
the chart, the selected color will refresh back to default color.
Any idea to keep my selected color for the pivot chart even i refresh the
chart?
Thanks.
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:
Changing a PivotChart Removes Series Formatting in Excel
http://support.microsoft.com/?id=215904
Jojomay wrote:
> I want to maintain my selected color for the pivot chart. But, when i filter
> the chart, the selected color will refresh back to default color.
>
> Any idea to keep my selected color for the pivot chart even i refresh the
> chart?
>
> Thanks.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks