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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|