Display Charts on click like how it is in Picassa

[c.vaibhav]

Dear Friends,

I have an Excel Workbook with a worksheet containing around 5-6 charts placed side by side. When user clicks on any chart I want that particular chart to Zoom and come in the centre whereas the background must become inactive (Similar to how Picassa Photo Viewer works)..

If this is possible in MS Excel 2003 then nothing like it. If not, Can you please suggest some other platform where it is possible?

Regards,
Vaibhav

[Keyur]

Hi Vaibhav
Use the code below to zoom in an out.
note that
1. I do not know how to make excel inactive while you view this chart. but if you have all charts on a seperate sheet you can use deactivate sheet event i.e. when sheet is deactivate resize any zoomed in chart (see next note)
2. for multiple charts every time a chart is click you will have to make sure the others are back to original. add a seperate zoomin variable for each chart so you can track what stage is a chart at.
3. you will have to make sure that charts are resized to its original before closing the file since initial zoomein value will be false. there are ways around this i am sure but i will leave that now.
4. modify the chart names and scale factors per your need.

Please Login or Register  to view this content.

hope this helps.

[shg]

Try this:

In a code module:

Please Login or Register  to view this content.

In the sheet module:

Please Login or Register  to view this content.

Right click the charts of interest and assign macro ChartZoom

[c.vaibhav]

Hey,
Thanks a lot both of you. both the solutions works!!!

Thanks once again..

[karan]

@shg: great solution..

--Karan--