http://www.excelforum.com/showthread.php?t=628724

Hi this is a previous post i posted bu tis not really relevant to what iam enquiring abot here.

In the file attached there is a monthly matrix, a lookup sheet and a graph sheet. On the graph sheet i require a for each of the services in the matrix that have bee nconverted ito sheet4. Monthly trend (graph sheet) already has the required three graphs for Aberdeen service. I need a graphs for all of the services in the matrix/table and would like to know if there is a way of doing this quickly or quicker than manulaly producing the graph for each service. i.e. is it possible to somehow code something that will do this quicly beacuse the table is likely to be extended to around 40 services next month and it will require a lot of effort to manually do each graph

Anyone any ideas, thanks