| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Possible to have a "dynamic" pivot chart title?
Hi,
I have made a pivot chart and one of the "report filter" is "country" and I can select "ALL" or "multiple countries". Question: Is it possiple - in the pivot chart - to have the CHART TITLE linked to REPORT FILTER? That is, if I choose "ALL" the report title would be "ALL" and if I select (Sweden, USA) it would read "Sweden, USA"? Kindly, Mikael |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Possible to have a "dynamic" pivot chart title?
Select the pivot chart
On the Ribbon, click the Insert tab, and insert a text box. Click the border of the text box, to select it. Type an equal sign, and then click on the cell that contains the report filter. Press Enter, to complete the formula Format the text, and move the text box to the position you want it on the chart. Mikael Lindqvist wrote: Hi, I have made a pivot chart and one of the "report filter" is "country" and I can select "ALL" or "multiple countries". Question: Is it possiple - in the pivot chart - to have the CHART TITLE linked to REPORT FILTER? That is, if I choose "ALL" the report title would be "ALL" and if I select (Sweden, USA) it would read "Sweden, USA"? Kindly, Mikael -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a "tab name" the "chart title"? | Charts and Charting in Excel | |||
| "Dynamic" calculated fields in a pivot table | Excel Discussion (Misc queries) | |||
| What is the advantage of using a "Chart Title" object over just another text box? | Charts and Charting in Excel | |||
| how can I use "filter" but keep "title" row in sight? | Excel Discussion (Misc queries) | |||
| Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
Linear Mode
