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
[email protected]
"Richard Flame" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>
>
> --
> 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
>

[Richard Flame]

Thank You

Works Great!

A++

[Don Guillett]

glad to help

--
Don Guillett
SalesAid Software
[email protected]
"Richard Flame" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[jayjasonjay]

Hi I am new to VBA and I am trying to construct the same theory that was just outlined in the previous post but my data is by row not columns.

Each row contains a part number and the columns contain values on monthly sales.

Example:

Item Number Item Desc Jan-06 Feb-06 Mar-06 Apr-06

xyz 5 10 25 35
abc 8 2 5 55
vbs 55 788 88 55

I have about 100 lines of data and I would like to be able to highlight part number and have the chart show the data for just that item.

Thanks