Hello
I have a custom graph which has both stacked columns bar and a line graph
with pivot table. Everytime I refresh data, the graph switch to graph with
colums bars.
How can I lock a graph to prevent switching?
Thanks a lot, R.
Hello
I have a custom graph which has both stacked columns bar and a line graph
with pivot table. Everytime I refresh data, the graph switch to graph with
colums bars.
How can I lock a graph to prevent switching?
Thanks a lot, R.
Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:
Changing a PivotChart Removes Series Formatting in Excel
http://support.microsoft.com/?id=215904
Richard Vajsar wrote:
> Hello
> I have a custom graph which has both stacked columns bar and a line graph
> with pivot table. Everytime I refresh data, the graph switch to graph with
> colums bars.
> How can I lock a graph to prevent switching?
> Thanks a lot, R.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks