A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

log axes, chart titles, Rob Bovey, loadsaprobs



 
 
Thread Tools Display Modes
  #1  
Old October 9th, 2003, 02:09 PM
JoeD
external usenet poster
 
Posts: n/a
Default log axes, chart titles, Rob Bovey, loadsaprobs


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


  #2  
Old October 12th, 2003, 03:38 AM
Tushar Mehta
external usenet poster
 
Posts: n/a
Default log axes, chart titles, Rob Bovey, loadsaprobs

[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

In article , is@thiswise?com
says...

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



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:24 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.