A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Multi-level Category Axis Fails with 100 rows of data



 
 
Thread Tools Display Modes
  #1  
Old April 13th, 2010, 03:48 PM posted to microsoft.public.excel.charting
Ivano Harris
external usenet poster
 
Posts: 1
Default Multi-level Category Axis Fails with 100 rows of data

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
Ads
  #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

  #3  
Old April 13th, 2010, 06:44 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

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

.

  #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

.

  #5  
Old April 16th, 2010, 01:03 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

I went back and tested this on my setup, which is Excel 2007 SP2 in a VM
running Win XP SP3. I have not consciously installed the hotfix. It may
have been done by MS Update, but it was not listed in Add/Remove Programs.

There was no trouble displaying up to almost 200 labels (as far as I went).

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 4/15/2010 9:00 AM, Ivano Harris wrote:
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
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:26 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.