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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|