position of graphs using vba

[khalid79m]

hi everyone need some help. I have a feed which is sent to me with sales scores,this sheet has 11 different sites on it, and each site has about 20 managers and each manager has at least 10 team leaders. I am producing sales reports per manager. I have all the necessary scripts in place to do this however, the problem i have is that I cant get the graphs to where i want them on the screen. How can i using vba set a position for a graph/chart?

[Leith Ross]

Hello Khalid79m,

This macro places the top left corner of the first charton the sheet in the cell you choose. This macro uses cell E10. You can change this to what you want to use.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[khalid79m]

thankyou so much. I wonder if you could offer some advice...

I have to produce some reports, I work for a large organisation and the reports are reporting call quality. I have 13 site for this one and again each site has 5 to 10 managers and each manager has upto 10 team leaders. I need to produce 1 report for each manager. I get the data feed as sheet of information. I have been exploring pivot tables but so complex and hard to understand. I currently run a simlar report which I have written endless macros for. I was wondering is there any easy way of doing this ?

[Leith Ross]

Hello Khalid79m,

If I could see the a sample sheet, I could make some suggestions.

Sincerely,
Leith Ross

[khalid79m]

I dont have a sample on this laptop, will send one to you via mail. Monday (Uk)

Thanks in advance M