chart
 

Hi!,

I remember 2 years back i have done this type of chart from Scenarios or
goal seek not excatly rem, but now i forget.. i want to do the chart in excel
2007.. Here is the story.. I had data for 3 different regions i.e east, west,
central on different tab. On the 1st sheet i want to display one single chart
(rest of the 3 tabs data) with the radio button 1 - East, 2-West, 3-Central.
When i click on 1st radio button i.e east the chart should be display with
the details from east, when i click on the radio button for West - the chart
should be displayed for West and the same should be for Central..

Can anyone please help me for this.. thanks