Multi-level Category Axis Fails with >100 rows of data

[Ivano Harris]

I'm having the same problem as posted on a few sites, one of which is below.
Is there any workaround, or plan to resolve this in the current version? Any
help appreciated.

http://www.tech-archive.net/Archive/Excel/microsoft.public.excel.charting/2009-02/msg00281.html

In my scenario, I'm building a Gantt chart style Promotional Calendar
organized by brand and then promotion name. The calendar can often have more
than 100 data points in larger markets. I've built a Gantt chart off of a
pivot table, with some VBA code to mimic functionality you'd get from slicers
in excel 2010 to let people filter the chart. It's pretty lame that the
chart just drops labels when you get over 100 data points, and not something
I can easily convey to an end user.

Thanks.
Ivano

 

[Jon Peltier]

This is a characteristic (I almost said "feature") of Excel 2007. I
don't know too much you can do about it. You could add an XY series,
with a point where every label should go, and apply labels to each point
using either one of the built-in options ("category" or "value") or
using Rob Bovey's Chart Labeler (free from http://appspro.com).

- Jon

 

[Ivano Harris]

I opened a ticket with MS, they pointed me to the following hotfix, which I
installed on a Win7 box and seems to have fixed my problem. Having issues
installing it on a winxp box, but once I do I'll let you know how that worked
as well. Here's the fix link, let me know what you find. Thanks.
Ivano

http://support.microsoft.com/default.aspx?scid=kb;EN-US;977031

 

[Ivano Harris]

As a follow-up, I got the WinXP hotfix installed and it resolved the problem
there as well. In addition to resolving the missing labels when there are
over 100 data points, the multi-level labels are much cleaner in general now
and seem to fit better within the tick marks than they did before.

 

[Jon Peltier]

I went back and tested this on my setup, which is Excel 2007 SP2 in a VM
running Win XP SP3. I have not consciously installed the hotfix. It may
have been done by MS Update, but it was not listed in Add/Remove Programs.

There was no trouble displaying up to almost 200 labels (as far as I went).

- Jon