Scatter chart does not refresh: HELP
 

Hi gurus

I have an X Y plot that does not refresh
Calculation is set to automatic.
F9 does not work.
From an extern ad inn i'm getting data into a range (matrix formula)
Made a range to XY chart by plain normal formulas like "=P3" in cell
AA3 and so forth..

AA3 is changing BUT not the XY chart?!


It seems to be a bug en excel.

Using Excel 2007

I've been surfing quit a while but I'am giving up now.
Please help.






Cheers

Scatter chart does not refresh: HELP
 

Teddy,
I am facing the exact same problem as you!

The data in the cells change but not the chart.

Please help!


"Teddy" wrote:

Hi gurus

I have an X Y plot that does not refresh
Calculation is set to automatic.
F9 does not work.
From an extern ad inn i'm getting data into a range (matrix formula)
Made a range to XY chart by plain normal formulas like "=P3" in cell
AA3 and so forth..

AA3 is changing BUT not the XY chart?!


It seems to be a bug en excel.

Using Excel 2007

I've been surfing quit a while but I'am giving up now.
Please help.






Cheers

Scatter chart does not refresh: HELP
 

if you right-click and choose Select Data then enter - this forces a
refresh - does the chart update correctly?



"Sherry" wrote in message
...
Teddy,
I am facing the exact same problem as you!

The data in the cells change but not the chart.

Please help!


"Teddy" wrote:

Hi gurus

I have an X Y plot that does not refresh
Calculation is set to automatic.
F9 does not work.
From an extern ad inn i'm getting data into a range (matrix formula)
Made a range to XY chart by plain normal formulas like "=P3" in cell
AA3 and so forth..

AA3 is changing BUT not the XY chart?!


It seems to be a bug en excel.

Using Excel 2007

I've been surfing quit a while but I'am giving up now.
Please help.






Cheers

Scatter chart does not refresh: HELP
 

if you right-click and choose Select Data then enter - this forces a
refresh - does the chart update correctly?



"Sherry" wrote in message
...
Teddy,
I am facing the exact same problem as you!

The data in the cells change but not the chart.

Please help!


"Teddy" wrote:

Hi gurus

I have an X Y plot that does not refresh
Calculation is set to automatic.
F9 does not work.
From an extern ad inn i'm getting data into a range (matrix formula)
Made a range to XY chart by plain normal formulas like "=P3" in cell
AA3 and so forth..

AA3 is changing BUT not the XY chart?!


It seems to be a bug en excel.

Using Excel 2007

I've been surfing quit a while but I'am giving up now.
Please help.






Cheers