|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 9th, 2006, 10:05 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
how to prevent Excel from reformatting a chart wen updating data?
I have data over time for different categories. when i change de reporting
time frame i want the chart colors to stay the same. Or when i change the scope in categories i still want the categorie chart to keep its color. How to stop excel from reformatting the colors? 
|
|
#2
February 9th, 2006, 10:10 AM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to prevent Excel from reformatting a chart wen updating data?
Hi,
I am assuming you are referring to Pivot charts in which case this is a know problem. If it's not a pivot chart then post back. Changing a PivotChart removes series formatting in Excel http://support.microsoft.com/default...;EN-US;Q215904 Cheers Andy Cmd_Marco wrote: I have data over time for different categories. when i change de reporting time frame i want the chart colors to stay the same. Or when i change the scope in categories i still want the categorie chart to keep its color. How to stop excel from reformatting the colors? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#3
February 10th, 2006, 01:56 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to prevent Excel from reformatting a chart wen updating da
Thx,
But i was referring to normal charts. I know it's not possible in Pivots. Marco "Andy Pope" wrote: Hi, I am assuming you are referring to Pivot charts in which case this is a know problem. If it's not a pivot chart then post back. Changing a PivotChart removes series formatting in Excel http://support.microsoft.com/default...;EN-US;Q215904 Cheers Andy Cmd_Marco wrote: I have data over time for different categories. when i change de reporting time frame i want the chart colors to stay the same. Or when i change the scope in categories i still want the categorie chart to keep its color. How to stop excel from reformatting the colors? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
|
#4
February 10th, 2006, 02:47 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to prevent Excel from reformatting a chart wen updating da
How are you changing the chart data then?
I haven't experienced the chart changing or losing it's formatting just be adjusting the size on data it references. Cheers Andy Cmd_Marco wrote: Thx, But i was referring to normal charts. I know it's not possible in Pivots. Marco "Andy Pope" wrote: Hi, I am assuming you are referring to Pivot charts in which case this is a know problem. If it's not a pivot chart then post back. Changing a PivotChart removes series formatting in Excel http://support.microsoft.com/default...;EN-US;Q215904 Cheers Andy Cmd_Marco wrote: I have data over time for different categories. when i change de reporting time frame i want the chart colors to stay the same. Or when i change the scope in categories i still want the categorie chart to keep its color. How to stop excel from reformatting the colors? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Macro to Copy & Paste | [email protected] | Worksheet Functions | 0 | December 1st, 2005 01:56 PM |
| From several workbooks onto one excel worksheet | steve | General Discussion | 6 | December 1st, 2005 08:03 AM |
| strategy for data entry in multiple tables | LAF | Using Forms | 18 | April 25th, 2005 04:04 AM |
| Excel Worksheets | Richard | General Discussion | 2 | July 8th, 2004 04:34 AM |
| Too many data points in Excel Chart | Jo | Charts and Charting | 1 | April 5th, 2004 03:53 PM |
Linear Mode
