I am not familar with the navision data query,
but I assume the data is generated on a paricular data sheet in a particular
format.
I assume you have been making your chart from the data that comes directly
from the query.
What I suggest is that if say the query response comes in on Sheet 1
you use sheet two with equations such as
in A1
=indirect("Sheet1!R"&Row()&"C"&Column(),False)
and copied ot all of the equivelant cells of interest from Sheet 1
Plot from Sheet2
then when the new data comes in on Sheet 1, The graph has a buffer between
it and the new data.

"Richard Thorneycroft (Husky Products)" wrote:

Hi BJ,

Sorry I don't understand what you have suggested. I'm not an advanced user
at all, sorry!

Thanks,

Richard

"bj" wrote:

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.