Thread
:
Dynamic Charting
View Single Post
#
2
Posted to microsoft.public.excel.charting
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett