| Home |
| Search |
| Today's Posts |
|
|
|
#1
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting of a data series in an Excel Chart? | Excel Discussion (Misc queries) | |||
| Updating Excel OLE chart data in PPT from Excel | Charts and Charting in Excel | |||
| Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
| How do I prevent data truncation from access to excel using MS Qu. | Excel Worksheet Functions | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Hybrid Mode
