Where are the pivottable chart buttons?

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

Guest

In Excel 2003, If you made a graph of a pivot table you would have buttons
inside the graph that would allow you to make certain selections or filters
inside the graph. Where are these in Excel 2007?

Can anybody help me?

Thanks in advance!
 
In Excel 2007 there's a PivotChart Filter Pane. It has dropdowns that
you can use to filter the fields.
 
And that is the only way to filter? The buttons in the graphs are not
featured anymore in Excel 2007?

Thanks,

Jelmer
 
Hi Debra,
I have just posted my own question on this and then found this thread. My
specific problem is that if the chart is printed or viewed by less
experienced users it's not obvious how the data is filtered. When the buttons
were visible so was the filtering data, how is this addressed in 2007?
 
Unfortunately, it's not addressed in Excel 2007.
You could add a title to the chart that links to a worksheet cell, and
show the selected date that way.
For example, if the date filter is in cell B3, select the chart title,
and type an equal sign. Then, click on cell B3, and press Enter
 
That's unfortunate. I often develop complicated models that are viewed and
used by people with much less Excel-saviness. Those buttons were extremely
user-friendly and allowed my clients to play around with the numbers and know
exactly what they were looking at. I hope that they return in the next
version.

- BRL
 
GTblearch said:
That's unfortunate. I often develop complicated models that are viewed and
used by people with much less Excel-saviness. Those buttons were extremely
user-friendly and allowed my clients to play around with the numbers and know
exactly what they were looking at. I hope that they return in the next
version.

- BRL
Click to expand...
 
Back
Top