Dynamic Charting
 

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

Dynamic Charting
 

One way.
Right click sheet tabview codeinsert this
If you select b1 other columns hidden
if you select c1 other columns hidden
etc
if you select a1 or d1 etc you see all.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row < 1 Then Exit Sub
Select Case Target.Column
Case 2: Columns("c:d").Hidden = True
Case 3: Range("b1,d1").EntireColumn.Hidden = True
Case 4: Columns("b:c").Hidden = True
Case Else
Columns("b:d").Hidden = False
End Select
End Sub
--
Don Guillett
SalesAid Software

"Richard Flame"
wrote in message
news:Richard.Flame.2admu0_1151942407.6032@excelfor um-nospam.com...

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

Dynamic Charting
 

Thank You

Works Great!

A++


--
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

Dynamic Charting
 

glad to help

--
Don Guillett
SalesAid Software

"Richard Flame"
wrote in message
news:Richard.Flame.2adr8b_1151948102.0386@excelfor um-nospam.com...

Thank You

Works Great!

A++


--
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