Hi,

You could also create a pivot table from your data and then plot that. You
can then group by Region, Zonal Level, and City and expand or collapse at any
level. When you do that to the pivot table it gets done automatically on the
chart.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Nikhil" wrote:

Hi...I have a column chart...what i did like to do is if the user clicks on
the column, there will be another chart that will come up...if he clicks on
the second column chart there would be a third chart that wil come up...

Basically i have data at Regional level, zonal level and then at city
level....

can you help?

Nikhil