I am using Excel 2002.

I have real time data being charted , and I manually calculate
ranges and sheets as needed. This is not a problem.

I have recently added charts to plot this data. Every time there is
a recalculation anywhere on the sheet (even areas not being charted)
the charts flicker. Since there is new data multiple times per
second , this is a problem.

Yes, I know about Application.DisplayAlerts = False, and tried
inserting that before EVERY calculation call. I even went so far as
to use the LockWindowUpdate api call, which freezes the entire app.
Unfortunately , as soon as you unfreeze, you get the redraw flash.

Is there no way to avoid this visible screen redraw?

Interestingly, I also have a chart in this same workbook, that is
created with
Set ChartSpreadSheet = CreateObject("OWC11.Spreadsheet"), that is
displayed in a userform. This chart does not exhibit the flashing on
update problem. I was trying to avoid using that method again for
this particular chart.

Wow, four identical messages in the course of four minutes. We are
volunteers reading your questions, none of them actually from Microsoft.
Give us a chance and we might get to it.

In any case,

Application.DisplayAlerts = False

is not what you're looking for. Perhaps you want

Application.ScreenUpdating = False

but if your issue occurs on automatic calculations in the worksheet, I'm not
sure it will help. If you're calculating in code, then it might actually
help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


wrote in message
...
I am using Excel 2002.

I have real time data being charted , and I manually calculate
ranges and sheets as needed. This is not a problem.

I have recently added charts to plot this data. Every time there is
a recalculation anywhere on the sheet (even areas not being charted)
the charts flicker. Since there is new data multiple times per
second , this is a problem.

Yes, I know about Application.DisplayAlerts = False, and tried
inserting that before EVERY calculation call. I even went so far as
to use the LockWindowUpdate api call, which freezes the entire app.
Unfortunately , as soon as you unfreeze, you get the redraw flash.

Is there no way to avoid this visible screen redraw?

Interestingly, I also have a chart in this same workbook, that is
created with
Set ChartSpreadSheet = CreateObject("OWC11.Spreadsheet"), that is
displayed in a userform. This chart does not exhibit the flashing on
update problem. I was trying to avoid using that method again for
this particular chart.

sorry about that duplication ;-). I posted using Microsofts web site, and
it threw an error on send. I thought it did not work , so I reentered it.

I mistyped , of course I meant
Application.ScreenUpdating = False

I think I'll have to use the ActiveX charting on a form, as this does not
appear to have the unfortunate flashing issue.



"Jon Peltier" wrote:

Wow, four identical messages in the course of four minutes. We are
volunteers reading your questions, none of them actually from Microsoft.
Give us a chance and we might get to it.

In any case,

Application.DisplayAlerts = False

is not what you're looking for. Perhaps you want

Application.ScreenUpdating = False

but if your issue occurs on automatic calculations in the worksheet, I'm not
sure it will help. If you're calculating in code, then it might actually
help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


wrote in message
...
I am using Excel 2002.

I have real time data being charted , and I manually calculate
ranges and sheets as needed. This is not a problem.

I have recently added charts to plot this data. Every time there is
a recalculation anywhere on the sheet (even areas not being charted)
the charts flicker. Since there is new data multiple times per
second , this is a problem.

Yes, I know about Application.DisplayAlerts = False, and tried
inserting that before EVERY calculation call. I even went so far as
to use the LockWindowUpdate api call, which freezes the entire app.
Unfortunately , as soon as you unfreeze, you get the redraw flash.

Is there no way to avoid this visible screen redraw?

Interestingly, I also have a chart in this same workbook, that is
created with
Set ChartSpreadSheet = CreateObject("OWC11.Spreadsheet"), that is
displayed in a userform. This chart does not exhibit the flashing on
update problem. I was trying to avoid using that method again for
this particular chart.

Oh yeah, that nice web interface. There are other ways to access the forums.
I use Outlook Express, and I've created a news account linked to the news
server msnews.microsoft.com.

Is there a lot of data in each chart? What version of Excel are you using?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"JoeG" wrote in message
...
sorry about that duplication ;-). I posted using Microsofts web site,
and
it threw an error on send. I thought it did not work , so I reentered it.

I mistyped , of course I meant
Application.ScreenUpdating = False

I think I'll have to use the ActiveX charting on a form, as this does not
appear to have the unfortunate flashing issue.



"Jon Peltier" wrote:

Wow, four identical messages in the course of four minutes. We are
volunteers reading your questions, none of them actually from Microsoft.
Give us a chance and we might get to it.

In any case,

Application.DisplayAlerts = False

is not what you're looking for. Perhaps you want

Application.ScreenUpdating = False

but if your issue occurs on automatic calculations in the worksheet, I'm
not
sure it will help. If you're calculating in code, then it might actually
help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


wrote in message
...
I am using Excel 2002.

I have real time data being charted , and I manually calculate
ranges and sheets as needed. This is not a problem.

I have recently added charts to plot this data. Every time there is
a recalculation anywhere on the sheet (even areas not being charted)
the charts flicker. Since there is new data multiple times per
second , this is a problem.

Yes, I know about Application.DisplayAlerts = False, and tried
inserting that before EVERY calculation call. I even went so far as
to use the LockWindowUpdate api call, which freezes the entire app.
Unfortunately , as soon as you unfreeze, you get the redraw flash.

Is there no way to avoid this visible screen redraw?

Interestingly, I also have a chart in this same workbook, that is
created with
Set ChartSpreadSheet = CreateObject("OWC11.Spreadsheet"), that is
displayed in a userform. This chart does not exhibit the flashing on
update problem. I was trying to avoid using that method again for
this particular chart.

As I said, Excel 2002. I have a lot of code written and working in that
version, and I haven't had time to install newer version to see what will
break.


There's quite a bit of data involved, its real time, and I have to do some
manipulation to get the data to display properly.

Working with the Active X module is more of a hassle than the built in
charting for obvious reasons. But, the upside is you get a userform that
you can actually put and size anywhere on the screen, as opposed to a chart
locked into the Excel app. I've done this before and I'm happy with the
results.





"Jon Peltier" wrote:

Oh yeah, that nice web interface. There are other ways to access the forums.
I use Outlook Express, and I've created a news account linked to the news
server msnews.microsoft.com.

Is there a lot of data in each chart? What version of Excel are you using?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"JoeG" wrote in message
...
sorry about that duplication ;-). I posted using Microsofts web site,
and
it threw an error on send. I thought it did not work , so I reentered it.

I mistyped , of course I meant
Application.ScreenUpdating = False

I think I'll have to use the ActiveX charting on a form, as this does not
appear to have the unfortunate flashing issue.



"Jon Peltier" wrote:

Wow, four identical messages in the course of four minutes. We are
volunteers reading your questions, none of them actually from Microsoft.
Give us a chance and we might get to it.

In any case,

Application.DisplayAlerts = False

is not what you're looking for. Perhaps you want

Application.ScreenUpdating = False

but if your issue occurs on automatic calculations in the worksheet, I'm
not
sure it will help. If you're calculating in code, then it might actually
help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


wrote in message
...
I am using Excel 2002.

I have real time data being charted , and I manually calculate
ranges and sheets as needed. This is not a problem.

I have recently added charts to plot this data. Every time there is
a recalculation anywhere on the sheet (even areas not being charted)
the charts flicker. Since there is new data multiple times per
second , this is a problem.

Yes, I know about Application.DisplayAlerts = False, and tried
inserting that before EVERY calculation call. I even went so far as
to use the LockWindowUpdate api call, which freezes the entire app.
Unfortunately , as soon as you unfreeze, you get the redraw flash.

Is there no way to avoid this visible screen redraw?

Interestingly, I also have a chart in this same workbook, that is
created with
Set ChartSpreadSheet = CreateObject("OWC11.Spreadsheet"), that is
displayed in a userform. This chart does not exhibit the flashing on
update problem. I was trying to avoid using that method again for
this particular chart.

Yep, you did say, right up there. I suspected you had 2007, which does not
deal very well with charts that have too much data. And for 2007, too much
means not very much.

If the userform/OWC approach suits you, then keep with it.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"JoeG" wrote in message
...
As I said, Excel 2002. I have a lot of code written and working in that
version, and I haven't had time to install newer version to see what will
break.


There's quite a bit of data involved, its real time, and I have to do some
manipulation to get the data to display properly.

Working with the Active X module is more of a hassle than the built in
charting for obvious reasons. But, the upside is you get a userform
that
you can actually put and size anywhere on the screen, as opposed to a
chart
locked into the Excel app. I've done this before and I'm happy with the
results.





"Jon Peltier" wrote:

Oh yeah, that nice web interface. There are other ways to access the
forums.
I use Outlook Express, and I've created a news account linked to the news
server msnews.microsoft.com.

Is there a lot of data in each chart? What version of Excel are you
using?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"JoeG" wrote in message
...
sorry about that duplication ;-). I posted using Microsofts web site,
and
it threw an error on send. I thought it did not work , so I reentered
it.

I mistyped , of course I meant
Application.ScreenUpdating = False

I think I'll have to use the ActiveX charting on a form, as this does
not
appear to have the unfortunate flashing issue.



"Jon Peltier" wrote:

Wow, four identical messages in the course of four minutes. We are
volunteers reading your questions, none of them actually from
Microsoft.
Give us a chance and we might get to it.

In any case,

Application.DisplayAlerts = False

is not what you're looking for. Perhaps you want

Application.ScreenUpdating = False

but if your issue occurs on automatic calculations in the worksheet,
I'm
not
sure it will help. If you're calculating in code, then it might
actually
help.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


wrote in message
...
I am using Excel 2002.

I have real time data being charted , and I manually calculate
ranges and sheets as needed. This is not a problem.

I have recently added charts to plot this data. Every time there is
a recalculation anywhere on the sheet (even areas not being charted)
the charts flicker. Since there is new data multiple times per
second , this is a problem.

Yes, I know about Application.DisplayAlerts = False, and tried
inserting that before EVERY calculation call. I even went so far
as
to use the LockWindowUpdate api call, which freezes the entire app.
Unfortunately , as soon as you unfreeze, you get the redraw flash.

Is there no way to avoid this visible screen redraw?

Interestingly, I also have a chart in this same workbook, that is
created with
Set ChartSpreadSheet = CreateObject("OWC11.Spreadsheet"), that is
displayed in a userform. This chart does not exhibit the flashing
on
update problem. I was trying to avoid using that method again for
this particular chart.