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  

Excel 2007: Missing drop-down buttons in Pivot Charts?



 
 
Thread Tools Display Modes
  #1  
Old March 6th, 2007, 10:36 AM posted to microsoft.public.excel.charting
Andre
external usenet poster
 
Posts: 84
Default 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  
Old May 31st, 2007, 10:55 AM posted to microsoft.public.excel.charting
Anders
external usenet poster
 
Posts: 72
Default 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  
Old May 31st, 2007, 11:08 AM posted to microsoft.public.excel.charting
Andre
external usenet poster
 
Posts: 84
Default 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  
Old June 12th, 2007, 01:04 PM posted to microsoft.public.excel.charting
Anders
external usenet poster
 
Posts: 72
Default 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  
Old June 12th, 2007, 01:17 PM posted to microsoft.public.excel.charting
Andre
external usenet poster
 
Posts: 84
Default 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  
Old December 15th, 2009, 01:39 PM posted to microsoft.public.excel.charting
Ed Saville
external usenet poster
 
Posts: 1
Default 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

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 04:57 PM.


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