Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to speed up response to scaling axes with code?
I am programming a chart building worksheet with vb, and I must scale
the axes based on a value within my spreadsheet. Right now, I am using the following commands: With ActiveChart.Axes(xlValue, xlPrimary) .MinimumScale = Worksheets("Aux").Range("M15") .MaximumScale = Worksheets("Aux").Range("M14") .MajorUnitIsAuto = True .MinorUnitIsAuto = True End With and doing this for each of the Primary, Secondary, and Category axes. However, with 32,000 data points and 8 to 16 series, this takes forever. Aside from just using a splash screen to help the user pass the time, does anyone have any suggestions on how to speed this up or how to do this a better way? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to speed up response to scaling axes with code?
This won't help so much with Excel 2007, but in any Excel version, it should
improve matters to construct your code like this: Application.ScreenUpdating = False With ActiveChart.Axes(xlValue, xlPrimary) .MinimumScale = Worksheets("Aux").Range("M15") .MaximumScale = Worksheets("Aux").Range("M14") .MajorUnitIsAuto = True .MinorUnitIsAuto = True End With Application.ScreenUpdating = True - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ wrote in message ups.com... I am programming a chart building worksheet with vb, and I must scale the axes based on a value within my spreadsheet. Right now, I am using the following commands: With ActiveChart.Axes(xlValue, xlPrimary) .MinimumScale = Worksheets("Aux").Range("M15") .MaximumScale = Worksheets("Aux").Range("M14") .MajorUnitIsAuto = True .MinorUnitIsAuto = True End With and doing this for each of the Primary, Secondary, and Category axes. However, with 32,000 data points and 8 to 16 series, this takes forever. Aside from just using a splash screen to help the user pass the time, does anyone have any suggestions on how to speed this up or how to do this a better way? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to speed up response to scaling axes with code?
On Apr 19, 9:52 am, wrote:
Right now, I am using the following commands: With ActiveChart.Axes(xlValue, xlPrimary) .MinimumScale = Worksheets("Aux").Range("M15") .MaximumScale = Worksheets("Aux").Range("M14") .MajorUnitIsAuto = True .MinorUnitIsAuto = True End With and doing this for each of the Primary, Secondary, and Category axes. Are you sure that scaling the axis is indeed the issue here, rather than the amount of data that excel has to lay-out? Maybe scaling the axes before setting the data for the chart would help improve the performance, if scaling is indeed the issue. David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Speed Up A Code | Excel Worksheet Functions | |||
Excel 2002: Need to speed up calculation and response time | Excel Discussion (Misc queries) | |||
Why has my mouse pointer response slowed to a crawl speed ? | Excel Worksheet Functions | |||
Need Code to Set Scaling Zoom in PageSetup in Auto_Open Sub | Excel Programming | |||
Code modification to accomodate scaling and print areas. | Excel Programming |