Number of visible Tick Labels limited to 100 in Excel 2007

[rrr]

Hi,

I have a line chart with more 120 categories.
Even though I set the "Interval between Labels" under "Format Axis" to "1",
the chart shows every other labels instead of every label.

Then I reduced the number of categories to exactly 100, and the chart then
showed every category. I then increased number of categories to 300, and the
chart showed every 3 categories. All the while, "Interval between Labels" was
set to 1.

It seems like Excel 2007 is limiting the number of visible categories to 100
or less. This doesn't happen on Excel 2003. Can anyone else confirm it, and
is there any way around it, such as adding some registry value?

Thanks,
-John

 

[Jon Peltier]

I've never noticed this, but I'm not surprised. The Excel 2007 charting
functionality has a great many things which have been changed arbitrarily,
as if the designers or coders had no practical experience with real
charting. I doubt there's a registry correction for this or any of the other
new "features".

- Jon

 

[rrr]

I got around it by adding another series where Y-value is exactly the Y-axis
min value, and then writing a macro to label each point with category names
using Points().Datalabel.Text property. With some formatting, I got it to
mimic the category axis.

Now if someone has some advise on the charting speed.... I then overlaid XY
chart with 14000 elements on it. My computer then froze with every chart
manipulation. When I copied the same chart as picture on PowerPoint, it also
made PowerPoint crawl. The workaround was to break up the series into
multiple series of 4000 points or less. - That was with Office SP1 and all
other latest patches applied.

 

[Jon Peltier]

You didn't need a macro, just add data labels using the category option.

- Jon

 

[rrr]

Ah, I didn't think of that. Thanks. -John