Chart Zoom(er)
Download the attached Excel file to see how the Chart Zoomer works. Click on the chart to Zoom and click again to size it back to normal.
Attachment | Size |
---|---|
ChartZoomer.xls | 55 KB |
»
- Vishesh's blog
- Login or register to post comments
- 19762 reads
Regarding chart events
can you tell me how to use chart click events along with an example.
Suppose I am having a chart1 showing top 10 region wise sales.
And now if I want to see the detailed data for a particular region , I will just click on a particular region on the chart1 and I will get data accordingly on the another chart or on a pivot table.
Please reply me with the same is the same blog or my specific mail id --> ershivamgupta.67@gmail.com
With Warm Regards
Shivam
please tell me how you do
please tell me how you do this?
See all the modules in the
See all the modules in the attached workbook. Create/copy similar modules in your own workbook. Close and open your workbook(should be macro enabled)
@shivam : unable to understand its working..
Its really an awsome job ...
I am unable to understand its code that how it is working and how would i implement it on my graphs.
Please provide me solution here on my specific mail id --> ershivamgupta.67@gmail.com
Thanks
awesome
There is no code visible. How did you do this?
code
There is code..
enable the macros, then press ALT + F11
Code is in modChartZoomer, clsChart, and Thisworkbook