Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Denis Le Bellego
 
Posts: n/a
Default Pivot table chart - turn off automatic color

Hi All,
I have a chart that contains several input created through a pivot table.
For making my chart clear I decided to apply 3 colors for my inputs some are
green, some are yellow and some are red.
But after each refresh, I get the default colors coming back.
How can I remove this default color setting and save my color choice ?
thanks for your replys
Denis
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Pivot table chart - turn off automatic color

Hi,

Loss of chart formating on refresh is a know bug.
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Denis Le Bellego wrote:
Hi All,
I have a chart that contains several input created through a pivot table.
For making my chart clear I decided to apply 3 colors for my inputs some are
green, some are yellow and some are red.
But after each refresh, I get the default colors coming back.
How can I remove this default color setting and save my color choice ?
thanks for your replys
Denis


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #3   Report Post  
Posted to microsoft.public.excel.charting
Denis Le Bellego
 
Posts: n/a
Default Pivot table chart - turn off automatic color

thanks a lot for your help
denis

"Andy Pope" wrote:

Hi,

Loss of chart formating on refresh is a know bug.
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Denis Le Bellego wrote:
Hi All,
I have a chart that contains several input created through a pivot table.
For making my chart clear I decided to apply 3 colors for my inputs some are
green, some are yellow and some are red.
But after each refresh, I get the default colors coming back.
How can I remove this default color setting and save my color choice ?
thanks for your replys
Denis


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table Chart el_grimley Excel Discussion (Misc queries) 4 November 18th 05 03:05 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
How do I go from "Chart View" to "Pivot Table Form" in a Pivot ta. Jersey Girl Excel Discussion (Misc queries) 1 March 10th 05 04:20 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 03:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"