View Single Post
  #4  
Old April 15th, 2010, 02:00 PM posted to microsoft.public.excel.charting
Ivano Harris[_2_]
external usenet poster
 
Posts: 3
Default Multi-level Category Axis Fails with 100 rows of data

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.

"Ivano Harris" wrote:

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...b;EN-US;977031

"Jon Peltier" wrote:

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/13/2010 10:48 AM, Ivano Harris wrote:
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/.../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

.