"Zombie" Charts gumming up the works...

Posted: 12-15-2005, 10:46 PM

Dave

Guest
Posts: n/a

I received the error "No more new fonts may be applied in this
workbook." while trying to copy a chart. Google pointed me to this
Microsoft knowledgebase article:

http://support.microsoft.com/default...215573&Product

Turns out that the default "auto scale fonts" setting on charts causes
many copies of fonts to be made within the workbook, eventually hitting
the limit of, I think, 512.

Although it is Windows-centric (registry? what registry?), the article
did contain the text of a macro that would clear the "auto scale fonts"
setting on all my charts, of which there were roughly 21 in the
workbook.

Or so I thought.

Ran the macro and it reported "187 charts have been altered." Huh?

I hacked the macro to generate a text listing of every chart it found:
there were, in fact, 187 charts in the workbook, several of them on
sheets that I thought had no charts at all!

One sheet has almost 80 of these "zombie" charts.

Any idea what the heck is going on here? I'm working on a copy of the
workbook to prevent stupidity from destroying my hard work, but can I
safely delete these legions of zombies?

Responses to ""Zombie" Charts gumming up the works..."

PhilD

Guest
Posts: n/a

Re: "Zombie" Charts gumming up the works...

Posted: 12-16-2005, 08:26 AM

Dave wrote:

> One sheet has almost 80 of these "zombie" charts.
>
> Any idea what the heck is going on here? I'm working on a copy of the
> workbook to prevent stupidity from destroying my hard work, but can I
> safely delete these legions of zombies?

I haven't had the exact same problem, but I have had odd things in what
I thought were empty cells. I can usually fix things like this:

Make a copy first (just in case). Save the charts as separate sheets
(you can put them back later). Assuming that you only have
data/formulae in the top left of each sheet, highlight all columns
AFTER the data and delete them (Edit -> Delete). Excel will add the
same number of fresh columns in their place. Then highlight all rows
UNDER the data and delete them, too. Hunt round for any other "empty"
cells and clear the contents of them, too. Save, close, reopen and see
what happens. Hopefully at this stage you can put the charts back
where they were!

Hope this helps.

PhilD

--
<><

Bob Greenblatt

Guest
Posts: n/a

Re: "Zombie" Charts gumming up the works...

Posted: 12-16-2005, 01:26 PM

I've seen a lot of workbooks where charts were either miniscule, or moved
off the worksheet. (You can do the latter via a macro by something like:
activechart.left=-2000) I don't know how this happens by accident, but it is
not uncommon. My suspicion is that the user(s) used the chart wizard to
create a chart, resized it accidentally, or put another object on top of it
and forgot it was there. In any case, as you have discovered, you can find
them via macro code, or goto-special-objects. And, of course, you should
delete all of them that are not used. It may make things run faster,
especially if the charts actually had working series that had to be
recalculated and redrawn.

--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

CyberTaz

Guest
Posts: n/a

Re: "Zombie" Charts gumming up the works...

Posted: 12-16-2005, 11:07 PM

This can also happen (especially with Pie Charts) if the Fill & Line of the
Chart Area is changed to None, perhaps no Legend, then the data on which the
chart is based gets deleted. Very difficult to spot if in a remote area of
the sheet even if 'traces' are left behind.

Regards |:>)

On 12/15/05 5:46 PM, in article
1134686792.119715.107370@o13g2000cwo.googlegroups. com, "Dave" <LAND@aol.com>
wrote:

> I received the error "No more new fonts may be applied in this
> workbook." while trying to copy a chart. Google pointed me to this
> Microsoft knowledgebase article:
>
>
> http://support.microsoft.com/default...215573&Product
>
> Turns out that the default "auto scale fonts" setting on charts causes
> many copies of fonts to be made within the workbook, eventually hitting
> the limit of, I think, 512.
>
> Although it is Windows-centric (registry? what registry?), the article
> did contain the text of a macro that would clear the "auto scale fonts"
> setting on all my charts, of which there were roughly 21 in the
> workbook.
>
> Or so I thought.
>
> Ran the macro and it reported "187 charts have been altered." Huh?
>
> I hacked the macro to generate a text listing of every chart it found:
> there were, in fact, 187 charts in the workbook, several of them on
> sheets that I thought had no charts at all!
>
> One sheet has almost 80 of these "zombie" charts.
>
> Any idea what the heck is going on here? I'm working on a copy of the
> workbook to prevent stupidity from destroying my hard work, but can I
> safely delete these legions of zombies?
>

LinkBack

Thread Tools

Display Modes

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may post replies You may not post attachments You may not edit your posts BB code is On Smilies are Off [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Forum Jump

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Will a normal Virus Scan determine if your PC has been turned into a "Zombie"?	Guest	Windows NT/2000/XP	0	09-05-2008 01:40 AM
"Connecting the dots" with Microsoft Excel charts	John Kounis	Mac Office Excel	1	05-12-2004 06:02 PM
Cookies will not enable even after changing settings for "Security" and "Privacy" tabs in "Internet Options", any suggestions?	tianimh	Windows XP Help & Support	2	01-27-2004 12:46 AM
"DOS" and prior "Microsoft Works"	Paul Blanchard	Windows XP New Users	5	12-04-2003 10:27 AM
Manual "Windows Update" produces "ActiveX/active scripting" error message even with "LOW" security level setting in "Trusted" Zone	Ray2	Windows XP Help & Support	1	11-14-2003 06:50 PM