PDA

View Full Version : Location Change for a Chart



archleo
12-12-2006, 08:47 AM
Hi to every one...

I have a workbook containing several worksheets. Every sheet has its own dynamic data which I update daily. Using this dynamic data, I create charts of 1 to 3 in each page. Monthly, these charts has to be renewed without deleting the old ones. Old charts has to be moved to a seperate sheet by renaming those "chart sheets" something like Sheet1_LastMonth, Sheet2_LastMonth.....and so on.

I have wrote down a piece of code for this, but I couldn't be able to change the location of the charts. In fact my code only "detects" the charts which are embedded in Sheet1. The rest is not detected.

Can you help me solving this mess??

Thanx

Levent

Erdin? E. Ka
12-12-2006, 03:03 PM
Hi Levent, Welcome to VBAX.

Can you upload your workbook? May i can help you more than only corresponding.

(By the way, if you want to get some backup older charts, you can use GraficExporter addin of Andy Pope.)

archleo
12-13-2006, 12:37 AM
Hi Erdinc...

Sorry but it is not possible to upload my workbook because of company secrets issues. Thanx for corresponding.

Regards

Levent

Erdin? E. Ka
12-13-2006, 04:57 PM
Doesn't matter Levent, you can analysis these links below:
You can find some useful examples...

http://www.andypope.info/charts.htm
http://www.tushar-mehta.com/excel/charts/
http://j-walk.com/ss/excel/tips/charts.htm