Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Keeping Custom Chart Settings
I'm working with a chart generated from a pivot table. I've used a 3D
chart in B&W because it will most likely be printed on a non-color printer by those who receive it. The problem I'm having is that any custom settings I use on the chart are "undone" if the source pivot table is adjusted. Is there a way to chart a pivot table so that the custom chart settings remain intact when the pivot table is adjusted, but allow the chart to continue to reflect the current (new data) pivot table information? (chart view will update with any pivot table manipulation.) -- Thanks for any and all suggestions. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Keeping Custom Chart Settings
This is a common problem with pivot charts - formatting is volatile. You
could make a custom chart type and apply it as needed, or record a macro while reformatting the chart, and repeat the macro as needed. Why does a 3D chart work better on a non-color printer? I'd think the B&W applied to a 2D chart would produce the best informational displays. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jim at Clark" wrote in message ... I'm working with a chart generated from a pivot table. I've used a 3D chart in B&W because it will most likely be printed on a non-color printer by those who receive it. The problem I'm having is that any custom settings I use on the chart are "undone" if the source pivot table is adjusted. Is there a way to chart a pivot table so that the custom chart settings remain intact when the pivot table is adjusted, but allow the chart to continue to reflect the current (new data) pivot table information? (chart view will update with any pivot table manipulation.) -- Thanks for any and all suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
saving autofiltercustom filter settings | Excel Worksheet Functions | |||
New laptop - where are the custom button settings filed ? | Excel Discussion (Misc queries) | |||
settings not saved w/custom view | Excel Worksheet Functions | |||
Keep custom toolbar settings - Help!! | Excel Discussion (Misc queries) | |||
Keep Custom Menu settings - help !! | Excel Worksheet Functions |