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  

Where are the pivottable chart buttons?



 
 
Thread Tools Display Modes
  #1  
Old October 24th, 2007, 04:32 PM posted to microsoft.public.excel.charting
Jelmer
external usenet poster
 
Posts: 2
Default Where are the pivottable chart buttons?

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!
  #2  
Old October 25th, 2007, 01:17 AM posted to microsoft.public.excel.charting
Debra Dalgleish
external usenet poster
 
Posts: 1,998
Default Where are the pivottable chart buttons?

In Excel 2007 there's a PivotChart Filter Pane. It has dropdowns that
you can use to filter the fields.

Jelmer wrote:
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!



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #3  
Old October 25th, 2007, 11:19 AM posted to microsoft.public.excel.charting
Jelmer
external usenet poster
 
Posts: 2
Default Where are the pivottable chart buttons?

And that is the only way to filter? The buttons in the graphs are not
featured anymore in Excel 2007?

Thanks,

Jelmer

"Debra Dalgleish" wrote:

In Excel 2007 there's a PivotChart Filter Pane. It has dropdowns that
you can use to filter the fields.

Jelmer wrote:
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!



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


  #4  
Old October 25th, 2007, 01:48 PM posted to microsoft.public.excel.charting
Debra Dalgleish
external usenet poster
 
Posts: 1,998
Default Where are the pivottable chart buttons?

That's right, there are no buttons on the pivot charts in Excel 2007.

Jelmer wrote:
And that is the only way to filter? The buttons in the graphs are not
featured anymore in Excel 2007?

Thanks,

Jelmer

"Debra Dalgleish" wrote:


In Excel 2007 there's a PivotChart Filter Pane. It has dropdowns that
you can use to filter the fields.

Jelmer wrote:

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!



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

  #5  
Old September 14th, 2009, 11:13 AM posted to microsoft.public.excel.charting
Russ
external usenet poster
 
Posts: 178
Default Where are the pivottable chart buttons?

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?

--
ATB

Russ


"Debra Dalgleish" wrote:

That's right, there are no buttons on the pivot charts in Excel 2007.

Jelmer wrote:
And that is the only way to filter? The buttons in the graphs are not
featured anymore in Excel 2007?

Thanks,

Jelmer

"Debra Dalgleish" wrote:


In Excel 2007 there's a PivotChart Filter Pane. It has dropdowns that
you can use to filter the fields.

Jelmer wrote:

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!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


  #6  
Old September 21st, 2009, 04:13 AM posted to microsoft.public.excel.charting
Debra Dalgleish
external usenet poster
 
Posts: 1,998
Default Where are the pivottable chart buttons?

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

Russ wrote:
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?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

  #7  
Old September 30th, 2009, 04:20 PM posted to microsoft.public.excel.charting
GTblearch
external usenet poster
 
Posts: 6
Default Where are the pivottable chart buttons?

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

"Debra Dalgleish" wrote:

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

Russ wrote:
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?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com


  #8  
Old May 25th, 2010, 02:08 PM posted to microsoft.public.excel.charting
AnnieK
external usenet poster
 
Posts: 2
Default Where are the pivottable chart buttons?



"GTblearch" wrote:

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

"Debra Dalgleish" wrote:

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

Russ wrote:
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?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com


  #9  
Old May 25th, 2010, 02:38 PM posted to microsoft.public.excel.charting
AnnieK
external usenet poster
 
Posts: 2
Default Where are the pivottable chart buttons?

I am not happy about not having the same if not better functions as 2003; I
feel that I have been short changed. I upgrade for better functions not less.
I am not the best chart maker but I did some impressive Pivot charts, they
were so easy. There is a fantastic product called Xecelsius that uses your
Excel spreadsheets as a source data. Its part of the Crystal Report Solutions
owned I think by SAP. So far I am doing ok self learning (as mentioned I am
not a great charter). Those of you with good chart skills would master it in
the blink of an eye. I am sure it is expensive but they allow you a 30 day
trial. If you like it and I am sure you can impress the boss who will more
than likely want it. Ufortunately MS have dropped the ball on this one.

"AnnieK" wrote:



"GTblearch" wrote:

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

"Debra Dalgleish" wrote:

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

Russ wrote:
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?



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com


 




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 05:04 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.