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
|
|||
|
|||
Excel 2007: Missing drop-down buttons in Pivot Charts?
Dear all,
when creating a pivot chart from a pivot table, there appears only a very basic chart. What is basically missing are the drop-down buttons in which one can select the variables to display. In addition drag-and-drop within the table does not work any longer (not surprising, as the buttons are missing), but it does not work any longer as well from the variable list. All configuration is now done via the "PivotCart Filter Pane". However, this filter pane is very unfortunate, since it does not display the names of the variables in the diagram any longer. So, if you have two variables, both having the categories 0 and 1, then it says only 1 and 0 on the x-axis and 1 and 0 in the legend, but you can't see in the diagram which variable is displayed on the x-axis and which one in the legend. You need the filter pane for that. That is not only extremely confusing, error prone, and uncomfortable as compared to the old style, but requires the manual entering of labels for each diagram if they are printed. However, in the Excel 2007 help, a classical pivot chart showing the pull-down variable buttons is depicted. Thus, I hope that this feature can be turned on somewhere. Can anybody help here? Thanks a lot for your help & Kind Regards, Andre |
#2
|
|||
|
|||
Excel 2007: Missing drop-down buttons in Pivot Charts?
I have the same problem, so I was sad to see, that nowone had replied.
Have you solved the problem anyway? best regards Anders "Andre" skrev: Dear all, when creating a pivot chart from a pivot table, there appears only a very basic chart. What is basically missing are the drop-down buttons in which one can select the variables to display. In addition drag-and-drop within the table does not work any longer (not surprising, as the buttons are missing), but it does not work any longer as well from the variable list. All configuration is now done via the "PivotCart Filter Pane". However, this filter pane is very unfortunate, since it does not display the names of the variables in the diagram any longer. So, if you have two variables, both having the categories 0 and 1, then it says only 1 and 0 on the x-axis and 1 and 0 in the legend, but you can't see in the diagram which variable is displayed on the x-axis and which one in the legend. You need the filter pane for that. That is not only extremely confusing, error prone, and uncomfortable as compared to the old style, but requires the manual entering of labels for each diagram if they are printed. However, in the Excel 2007 help, a classical pivot chart showing the pull-down variable buttons is depicted. Thus, I hope that this feature can be turned on somewhere. Can anybody help here? Thanks a lot for your help & Kind Regards, Andre |
#3
|
|||
|
|||
Excel 2007: Missing drop-down buttons in Pivot Charts?
Sorry, no solution yet. I searched the net for more info and from some
Microsoft Excel developer blog I got the impression that this feature is no longer available, i.e. it cannot be turned on somewhere. As far as I understood they removed this feature to enable the newer more advanced graphical options/controls of the diagrams. I prefered the old way :-( If you here some workaround, it would be great if you could post it to this thread, as I'm still watching it. Cheers, Andre "Anders" wrote: I have the same problem, so I was sad to see, that nowone had replied. Have you solved the problem anyway? best regards Anders "Andre" skrev: Dear all, when creating a pivot chart from a pivot table, there appears only a very basic chart. What is basically missing are the drop-down buttons in which one can select the variables to display. In addition drag-and-drop within the table does not work any longer (not surprising, as the buttons are missing), but it does not work any longer as well from the variable list. All configuration is now done via the "PivotCart Filter Pane". However, this filter pane is very unfortunate, since it does not display the names of the variables in the diagram any longer. So, if you have two variables, both having the categories 0 and 1, then it says only 1 and 0 on the x-axis and 1 and 0 in the legend, but you can't see in the diagram which variable is displayed on the x-axis and which one in the legend. You need the filter pane for that. That is not only extremely confusing, error prone, and uncomfortable as compared to the old style, but requires the manual entering of labels for each diagram if they are printed. However, in the Excel 2007 help, a classical pivot chart showing the pull-down variable buttons is depicted. Thus, I hope that this feature can be turned on somewhere. Can anybody help here? Thanks a lot for your help & Kind Regards, Andre |
#4
|
|||
|
|||
Excel 2007: Missing drop-down buttons in Pivot Charts?
The only workaround I can think of is to use some VBA. I think I will give it
a shot and see how usefull it gets. best regards Anders "Andre" skrev: Sorry, no solution yet. I searched the net for more info and from some Microsoft Excel developer blog I got the impression that this feature is no longer available, i.e. it cannot be turned on somewhere. As far as I understood they removed this feature to enable the newer more advanced graphical options/controls of the diagrams. I prefered the old way :-( If you here some workaround, it would be great if you could post it to this thread, as I'm still watching it. Cheers, Andre "Anders" wrote: I have the same problem, so I was sad to see, that nowone had replied. Have you solved the problem anyway? best regards Anders "Andre" skrev: Dear all, when creating a pivot chart from a pivot table, there appears only a very basic chart. What is basically missing are the drop-down buttons in which one can select the variables to display. In addition drag-and-drop within the table does not work any longer (not surprising, as the buttons are missing), but it does not work any longer as well from the variable list. All configuration is now done via the "PivotCart Filter Pane". However, this filter pane is very unfortunate, since it does not display the names of the variables in the diagram any longer. So, if you have two variables, both having the categories 0 and 1, then it says only 1 and 0 on the x-axis and 1 and 0 in the legend, but you can't see in the diagram which variable is displayed on the x-axis and which one in the legend. You need the filter pane for that. That is not only extremely confusing, error prone, and uncomfortable as compared to the old style, but requires the manual entering of labels for each diagram if they are printed. However, in the Excel 2007 help, a classical pivot chart showing the pull-down variable buttons is depicted. Thus, I hope that this feature can be turned on somewhere. Can anybody help here? Thanks a lot for your help & Kind Regards, Andre |
#5
|
|||
|
|||
Excel 2007: Missing drop-down buttons in Pivot Charts?
Hi Anders,
if you have some success it would be great if you could share it, I would be very keen for a solution. If you like, you can email me directly as well: andre_xs (at) web.de Thanks a lot & Best wishes, Andre "Anders" wrote: The only workaround I can think of is to use some VBA. I think I will give it a shot and see how usefull it gets. best regards Anders "Andre" skrev: Sorry, no solution yet. I searched the net for more info and from some Microsoft Excel developer blog I got the impression that this feature is no longer available, i.e. it cannot be turned on somewhere. As far as I understood they removed this feature to enable the newer more advanced graphical options/controls of the diagrams. I prefered the old way :-( If you here some workaround, it would be great if you could post it to this thread, as I'm still watching it. Cheers, Andre "Anders" wrote: I have the same problem, so I was sad to see, that nowone had replied. Have you solved the problem anyway? best regards Anders "Andre" skrev: Dear all, when creating a pivot chart from a pivot table, there appears only a very basic chart. What is basically missing are the drop-down buttons in which one can select the variables to display. In addition drag-and-drop within the table does not work any longer (not surprising, as the buttons are missing), but it does not work any longer as well from the variable list. All configuration is now done via the "PivotCart Filter Pane". However, this filter pane is very unfortunate, since it does not display the names of the variables in the diagram any longer. So, if you have two variables, both having the categories 0 and 1, then it says only 1 and 0 on the x-axis and 1 and 0 in the legend, but you can't see in the diagram which variable is displayed on the x-axis and which one in the legend. You need the filter pane for that. That is not only extremely confusing, error prone, and uncomfortable as compared to the old style, but requires the manual entering of labels for each diagram if they are printed. However, in the Excel 2007 help, a classical pivot chart showing the pull-down variable buttons is depicted. Thus, I hope that this feature can be turned on somewhere. Can anybody help here? Thanks a lot for your help & Kind Regards, Andre |
#6
|
|||
|
|||
pivot chart filters
Hi i would love to know if anybody has found a fix for the pivot chart filter problem, i contacted Microsoft and actually spoke to a human being, he said that the problem did not exist but after some half hour he agreed that it did but said that it would have to be fixed in a future release...great
Andr wrote: Hi Anders,if you have some success it would be great if you could share it, I 12-Jun-07 Hi Anders, if you have some success it would be great if you could share it, I would be very keen for a solution. If you like, you can email me directly as well: andre_xs (at) web.de Thanks a lot & Best wishes, Andre "Anders" wrote: Previous Posts In This Thread: On Tuesday, March 06, 2007 4:36 AM Andr wrote: Excel 2007: Missing drop-down buttons in Pivot Charts? Dear all, when creating a pivot chart from a pivot table, there appears only a very basic chart. What is basically missing are the drop-down buttons in which one can select the variables to display. In addition drag-and-drop within the table does not work any longer (not surprising, as the buttons are missing), but it does not work any longer as well from the variable list. All configuration is now done via the "PivotCart Filter Pane". However, this filter pane is very unfortunate, since it does not display the names of the variables in the diagram any longer. So, if you have two variables, both having the categories 0 and 1, then it says only 1 and 0 on the x-axis and 1 and 0 in the legend, but you can't see in the diagram which variable is displayed on the x-axis and which one in the legend. You need the filter pane for that. That is not only extremely confusing, error prone, and uncomfortable as compared to the old style, but requires the manual entering of labels for each diagram if they are printed. However, in the Excel 2007 help, a classical pivot chart showing the pull-down variable buttons is depicted. Thus, I hope that this feature can be turned on somewhere. Can anybody help here? Thanks a lot for your help & Kind Regards, Andre On Thursday, May 31, 2007 5:55 AM Ander wrote: I have the same problem, so I was sad to see, that nowone had replied. I have the same problem, so I was sad to see, that nowone had replied. Have you solved the problem anyway? best regards Anders "Andre" skrev: On Thursday, May 31, 2007 6:08 AM Andr wrote: Sorry, no solution yet. Sorry, no solution yet. I searched the net for more info and from some Microsoft Excel developer blog I got the impression that this feature is no longer available, i.e. it cannot be turned on somewhere. As far as I understood they removed this feature to enable the newer more advanced graphical options/controls of the diagrams. I prefered the old way :-( If you here some workaround, it would be great if you could post it to this thread, as I'm still watching it. Cheers, Andre "Anders" wrote: On Tuesday, June 12, 2007 8:04 AM Ander wrote: The only workaround I can think of is to use some VBA. The only workaround I can think of is to use some VBA. I think I will give it a shot and see how usefull it gets. best regards Anders "Andre" skrev: On Tuesday, June 12, 2007 8:17 AM Andr wrote: Hi Anders,if you have some success it would be great if you could share it, I Hi Anders, if you have some success it would be great if you could share it, I would be very keen for a solution. If you like, you can email me directly as well: andre_xs (at) web.de Thanks a lot & Best wishes, Andre "Anders" wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice SQLEXPRESS Connection String Features http://www.eggheadcafe.com/tutorials...ction-str.aspx |
Thread Tools | |
Display Modes | |
|
|