Dynamic Charting

  • Thread starter Thread starter Richard Flame
  • Start date Start date
R

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
 
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]...
 
Back
Top