This is a known issue with pivot charts:

http://pubs.logicalexpressions.com/P...?ID=209#jon026

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Help with Pivot Chart- Combination wrote:

Hi,

I want to use a line and bar combination chart in a Pivot Chart but
everytime I refresh the report it reverts back to bar chart. Is there any way
I can fix the chart format?