Hi all,

I have an Excel spreadsheet that has a pivot table on it which shows data for various business codes. When creating a Pivot Chart I select the custom chart-type of Line - Column on 2 axes. However, when I select a change in the business code from the drop-down menu at the top it defaults back to a different chart type. It doesn't seem to do this when I use any other type, just this Line - Column on 2 axes. Does anyone know why, or how I can make it stop doing this?

Many thanks

Leanne