Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 2nd 10, 07:00 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 62
Default Chart Stopped Updating

Hi

I have a number of DDE links that I use to increment Rows D to I every
second, providing me with a method of data logging my DDE Links.
I find that my chart works fine up to about 247 rows then stops updating.
I have just upgraded from 2003 to 2007 version of Excel.
Any ideas.

Thanks
Alec

  #2   Report Post  
Old January 3rd 10, 07:56 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 119
Default Chart Stopped Updating

when you saved into 2007, you keep the old file format or use the new format?

if using new, pls make sure you are using xlsm.

if you are using the compatibility mode, please check make to make sure you
click the security setting to low.



"Alectrical" wrote:

Hi

I have a number of DDE links that I use to increment Rows D to I every
second, providing me with a method of data logging my DDE Links.
I find that my chart works fine up to about 247 rows then stops updating.
I have just upgraded from 2003 to 2007 version of Excel.
Any ideas.

Thanks
Alec

  #3   Report Post  
Old January 3rd 10, 05:45 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 62
Default Chart Stopped Updating

I created a new file with file extension .xlsm.
Columns D to I continue updating with no problems, the chart just freezes
after about 247 rows.
When I created the line chart, I selected columns D to I as input data and
Column C for my X axis ( there is no data in column C) this appears to work
up to row 247.

Thanks
Alec

"Leung" wrote:

when you saved into 2007, you keep the old file format or use the new format?

if using new, pls make sure you are using xlsm.

if you are using the compatibility mode, please check make to make sure you
click the security setting to low.



"Alectrical" wrote:

Hi

I have a number of DDE links that I use to increment Rows D to I every
second, providing me with a method of data logging my DDE Links.
I find that my chart works fine up to about 247 rows then stops updating.
I have just upgraded from 2003 to 2007 version of Excel.
Any ideas.

Thanks
Alec

  #4   Report Post  
Old January 3rd 10, 06:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 62
Default Chart Stopped Updating

Additionally

I need the chart to automatically expand with increased incremental data,
this is not happening at present.

"Alectrical" wrote:

I created a new file with file extension .xlsm.
Columns D to I continue updating with no problems, the chart just freezes
after about 247 rows.
When I created the line chart, I selected columns D to I as input data and
Column C for my X axis ( there is no data in column C) this appears to work
up to row 247.

Thanks
Alec

"Leung" wrote:

when you saved into 2007, you keep the old file format or use the new format?

if using new, pls make sure you are using xlsm.

if you are using the compatibility mode, please check make to make sure you
click the security setting to low.



"Alectrical" wrote:

Hi

I have a number of DDE links that I use to increment Rows D to I every
second, providing me with a method of data logging my DDE Links.
I find that my chart works fine up to about 247 rows then stops updating.
I have just upgraded from 2003 to 2007 version of Excel.
Any ideas.

Thanks
Alec



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel has stopped showing graphs on seperate chart tabs JonesyAD Charts and Charting in Excel 0 September 13th 07 05:22 AM
Updating Chart PiB311 Excel Discussion (Misc queries) 0 July 16th 07 05:10 PM
My chart is not updating Zaid Charts and Charting in Excel 0 April 24th 07 02:32 PM
Why has the sum function stopped auto-updating? Paul Excel Discussion (Misc queries) 1 August 7th 06 10:55 AM
Updating Chart Stan Charts and Charting in Excel 0 June 12th 06 03:17 AM


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017