Dynamic Graph

Hey,

I am producing a CD accounting spreadsheet which filters the data in one worksheet, through criteria selection, into another worksheet. I would like to produce a graph from the filtered data on the press of a macro button e.g. (produce graph button > 'graph' worksheet) , but I am unsure of how to do this. I would like the graph to take all of the CD reference codes e.g. HUX OO2 etc from the 'DATA' worksheet, displaying each reference on the horizontal axis. I would then like the graph to read the filtered CD reference codes in the 'Filtered data' worksheet, and then populate the correct CD reference on the horizontal axis of the graph. The vertical axis should go from 1 to 10. The purpose is so that I can visually see the quantity of individual CD's that were sold in the selected month/year for a specific record label. I am not sure wether this is possible or not, but I would be grateful for any suggestions! The spreadsheet file can be obtained from the link below - hopefully that will make things more understandable.

http://www.filefactory.com/file/67db34/

Many thanks,

Ben