Hi all,

I am running Excel 2002.

I have a spreadsheet with a database query from a Navision database. From
the data I have created a bar chart on a seperate sheet and whenever the data
refreshes the chart loses it's formatting.

Any ideas of how I can retain the formatting?

Many thanks in advance for your help.