I have a pivot chart formated as bars with only one serie formated as line
and every time I manipulate the chart this line serie miss the configuration,
returning as a bar chart.
I have a pivot chart formated as bars with only one serie formated as line
and every time I manipulate the chart this line serie miss the configuration,
returning as a bar chart.
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
http://support.microsoft.com/?id=215904
Marcos Novaki wrote:
> I have a pivot chart formated as bars with only one serie formated as line
> and every time I manipulate the chart this line serie miss the configuration,
> returning as a bar chart.
--
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