log axes, chart titles, Rob Bovey, loadsaprobs

[JoeD]

In the past few days I have been building a workbook (6Mb
and growing) that contains a sheet displaying about 20
charts. I have incorporated the little trick which
references the chart title to a cell reference (very
handy).
Also downloaded the Add-in from Rob Bovey to change data
labels (as suggested by tusha mehta`s tutorial on how to
customise Excel chart log axes). I ended up not needing
it.

When worked on, the workbook is running very slow (Excel
is using 98-99% of my processing) and appears to think a
lot before allowing access to any chart I want to edit.

Can this be the title cell reference doing this?

I intend to duplicate this worksheet (Copy/Move) within
the Workbook (for other data sets) and am concerned about
the problem getting worse.

This particular file isn't the biggest or most complex i
have going here.

any ideas?

Joe

 

[Tushar Mehta]

[This followup was posted to microsoft.public.excel.charting and a copy
was sent to the cited author.]

Neither linking a chart title to a worksheet cell nor Rob's add-in use
any significant resources.

For the 20 charts, how large is the data set for each? Are the data
just numbers or the result of formulas? Are you using any VBA code to
update your data? Are you using any UDFs? How are the data updated?
Those are far more likely to contribute to your processor utilization
than chart title links or data label links.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office