View Single Post
  #2  
Old April 13th, 2010, 05:13 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Multi-level Category Axis Fails with 100 rows of data

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