Question About Pivot Tables
 

Hi ,

I have a pivot table and chart is connected to pivot table.
How do i change the title of the graph , when i select different country,
state,customer etc from the list.
Example : If i change country to USA, Chart title should be 'Bookings for
USA'.

Thanks in advance,

Shashi

Question About Pivot Tables
 

Works Great..... Thanks.
"Debra Dalgleish" wrote in message
...
You can link the chart title to a cell on the worksheet. For example, if
the PivotTable dropdown is in cell B2:

1. Enter the following formula in cell D1:
="Bookings for " & B2
2. Select the chart title, and click in the Formula bar.
3. Type an equal sign, and click on cell D1, which contains the formula
The chart title formula will be: =Sheet1!$D$1
4. Press the Enter key.

The chart title will change when a new selection is made in the dropdown.

Shashi Bhosale wrote:
I have a pivot table and chart is connected to pivot table.
How do i change the title of the graph , when i select different
country,
state,customer etc from the list.
Example : If i change country to USA, Chart title should be 'Bookings
for
USA'.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html