VBA for Excel graph

[Anil2007]

Hi

I need a help on the attch garph. wat i need help is that whenever i selct the BU in cell M2 there correspond BG IN CELL M3 will

Filter out and the graph will autamatically update

I don't knw much about the graph so plz help me out

[Andy Pope]

Your example workbook does not contain the chart data, but rather links to the file,
C:\Temp\[Copy of Kristi report out V5.xls]BG'!

You can use Autofilter to reduce charts contents.