View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
Matt McQueen Matt McQueen is offline
external usenet poster
 
Posts: 23
Default ChartArea.left reporting incorrectly?

Interesting tip Jon, thanks for that. I employed it prior to the With - End
With statement I was using on each successive plot to format and orient it.
Previously it was misalinging the final two plots created... with DoEvents it
only misaligned the last plot. I added a DoEvents immediately after the
realignment as well, and Excel turned ScreenUpdating back on (!). Figured I
was in over my head at that point.

In the end I've hardcoded the numbers since they'll nearly always be
constant. Thanks anyway.