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:

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

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

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

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

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