Large amount of data into chart with options to filter?

[chifans]

Hi All,

I'd appreciate any help with some [FONT=inherit !important][FONT=inherit !important]data[/FONT][/FONT].

Basically the data looks at sales of two brands in 3 territories which are also split down into sub territories and postal areas over a 12 month period.

What i'd like to be able to do is chart the data (pivot chart??) so that i can filter down by various options ( territory/sub territory/postal area etc) to be able to look at either individual brand sales or compare by the two brands in that particular option?

Any help would be greatly appreciated!!

 

[sergioMabres]

Pivot graph or just a graph and
Add Slicer to filter the chart
Use slicers to filter PivotTable data - Excel - Office.com
I hope this helps