Dynamic Charting

[pickslides]

Hi all,

I can use a pivot chart and apply filters to make a dynamic chart for my data sets. But I was wondering if I could change the variables on the chart axis as well.

For example I might have some transactional data, consultant, time, transaction type, mins per transaction etc...

I might make one chart that has consultant names in the x-axis and volume of transactions in the y-axis. Is there a way it could then pivot to be time of day on the x-axis and total transactions in the y-axis?

Have attached some sample data and charts, can I make these two charts into just the one letting the user choose the variables they want to see?

Can I achieve this in a user friendly presentation without needing to change the pivottable?


Kind regards,