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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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:
 
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
 
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:
 
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
 
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_x
(at
web.d

Thanks a lot
Best wishes
Andr


:

Previous Posts In This Thread:

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

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 regard
Ander

"Andre" skrev:

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
Andr

:

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 i
a shot and see how usefull it gets
best regard
Ander

"Andre" skrev:

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_x
(at
web.d

Thanks a lot
Best wishes
Andr


:


Submitted via EggHeadCafe - Software Developer Portal of Choice
SQLEXPRESS Connection String Features
http://www.eggheadcafe.com/tutorial...0-874be4fd7553/sqlexpress-connection-str.aspx
 
Back
Top