Dynamic Charting

[Richard Flame]

Hi everyone,

If i have a data such as:

Chicago ......Newport.........Bellevue
January.........52.............67.................76
February........34 .........57.................98
March...........56.............67................45
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

 

[Don Guillett]

One way.
Right click sheet tab>view code>insert 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
(e-mail address removed)
"Richard Flame" <[email protected]>
wrote in message
news:[email protected]...

 

[Richard Flame]

Thank You

Works Great!

A++

 

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
(e-mail address removed)
"Richard Flame" <[email protected]>
wrote in message
news:[email protected]...