Hi everyone,

Hope you can help - I have produced a report for work that has two components; a pivot table that tracks two sales categories over time. The rows are years/months, there are 4 columns the contain two deal types, which are split into two more columns to show number of each deal type and the percentage relative to the other deal type (hope this makes sense)

Whilst I have all this data in the pivot table, I only want to show the percentage value for one of the deal types on a chart (They both add up to 100%). If I generate a pivotchart from the table it changes the pivottable if I remove fields from the chart, and the number of rows (months) will change so I don't want to use a static range reference.

Any ideas? I thought of creating a static table and then using GETPIVOTDATA and a normal chart to display, but I was wondering if there was any other solution to this?

thanks

Jack