Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Line chart or scatter chart?? | Charts and Charting in Excel | |||
Creating a mix of column and scatter chart on one chart. | Charts and Charting in Excel | |||
Pivot Chart Refresh cancels all chart formatting | Charts and Charting in Excel | |||
Scatter chart displays as line chart | Charts and Charting in Excel | |||
scatter chart insists on plotting as a line chart | New Users to Excel |