Have you tried using an intermediate data set that references your input data
and plot the intermediate data set?

"Richard Thorneycroft (Husky Products)" wrote:

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.