(Msg. 1) Posted: Wed Aug 06, 2008 8:01 pm
Post subject: Number of visible Tick Labels limited to 100 in Excel 2007 Add to elertz Archived from groups: microsoft>public>excel>charting (more info?)
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?
(Msg. 2) Posted: Thu Aug 07, 2008 7:55 am
Post subject: Re: Number of visible Tick Labels limited to 100 in Excel 2007 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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" <rrr DeleteThis @discussions.microsoft.com> wrote in message
news:5E0C2D45-A747-47C0-9635-CCF22EAF7373@microsoft.com...
> 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
(Msg. 3) Posted: Thu Aug 07, 2008 1:13 pm
Post subject: Re: Number of visible Tick Labels limited to 100 in Excel 2007 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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.
(Msg. 4) Posted: Fri Aug 08, 2008 9:42 am
Post subject: Re: Number of visible Tick Labels limited to 100 in Excel 2007 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
You didn't need a macro, just add data labels using the category option.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"rrr" <rrr.TakeThisOut@discussions.microsoft.com> wrote in message
news:A25FC595-9F7E-4349-918A-702073287D0B@microsoft.com...
>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.
(Msg. 5) Posted: Sat Aug 09, 2008 3:38 pm
Post subject: Re: Number of visible Tick Labels limited to 100 in Excel 2007 Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Office