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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"rrr" wrote in message
...
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