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.