View Single Post
  #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