Hi everyone,

If i have a data such as:

Chicago ......Newport.........Bellevue
January.........52.............67................. 76
February........34 .........57.................98
March...........56.............67................4 5
April.............67............36................ ..67
May..............67...........56.................. 99

and i want to display a chart for each branch seperatly. I know i can
display in a column chart the volume sold in all 3 branches with the
month diplayed, but i'm trying to create a scollable menu(for example)
where i can select the branch and display its data of each month
seperatly from the other branches without having multiple charts. Any
help would be much appreciated..Tks


--
Richard Flame
------------------------------------------------------------------------
Richard Flame's Profile: http://www.excelforum.com/member.php...o&userid=35944
View this thread: http://www.excelforum.com/showthread...hreadid=557867