Pivot Chart Title, depending on measur

[shiftyspina]

Hi

I have created a pivot chart from a pivot table, and i want to have a title, but i want this to pick up what measure is being looked at.

My measures are;

Sales.
Quantity.
Gross Margin.

The user will select one of these measures to look at and i want the title of the chart to change to that measure, its ok when you are looking at the chart in excel, but when it is printed other users would have no idea of what they are looking at.

Could anyone help me please?

Dan

[Andy Pope]

by measure do you mean the Report Filter?

Is so you can like the chart title to a cell.
http://www.andypope.info/tips/tip001.htm

[shiftyspina]

How easy is that!! Thank you very much

Yes i did mean report filter, sorry its because my data was labelled "measure" as the column header

Thanks again

Dan