Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart rotation
When I grab the corner of a 3D chart and rotate it, the chart tuns
white. It returns to normal when done. Can this white background be eliminated? I have a button and macro that makes it rotate and that white makes a terrible flicker. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart rotation
Hi
Have you tried putting in this line at the top of the code Application.Screenupdating = False You might also scatter in a few lines of DoEvents Excel 2007 in particular can be terrible at updating graphics & I find I have to drop DoEvents inside loops to make things "go" properly. regards Paul On Apr 1, 7:40*am, Fan924 wrote: When I grab the corner of a 3D chart and rotate it, the chart tuns white. It returns to normal when done. Can this white background be eliminated? * I have a button and macro that makes it rotate and that white makes a terrible flicker. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart rotation
Application.Screenupdating = False
This is the first thing I tried. Not any better. Could you give an example of DoEvents. I am not familiar with it. Thanks Paul |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Chart rotation
Hi
You just type DoEvents on a new line. It forces Excel to update the screen (amongst other things) before proceeding with the next line of code. You can put it into a block of code more than once, especially after code that updates the screen. I have sometimes had to use DoEvents DoEvents as it seems to make things update better than one such line - heaven knows why! regards Paul On Apr 1, 2:55*pm, Fan924 wrote: Application.Screenupdating = False This is the first thing I tried. Not any better. Could you give an example of DoEvents. I am not familiar with it. Thanks Paul |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie Chart - Rotation | Charts and Charting in Excel | |||
Job Rotation app? | Excel Discussion (Misc queries) | |||
Variable Chart Elevation & Rotation | Excel Programming | |||
Excel 2007 line chart automatic category axis text rotation | Charts and Charting in Excel | |||
Chart Rotation | Charts and Charting in Excel |