outline an excel graph
 

is there a way to create an outline of a graph, similar to the subtotals
function resulting ouline? For example, I have 10 unit numbers each number
has five different values i want to see, but then hide as I look at the next
unit number's five values in a bar graph.

Thanks!

outline an excel graph
 

Starting in A1 I have this data
Data A B C D E
one 2 60 5 7 2
two 3 70 10 8 4
three 4 80 15 9 6
four 5 90 20 10 8
five 6 100 25 11 10

Only 5 units numbers (A to E) but could be 10
In another area I have
Group D
one 7
two 8
three 4
four 5
five 6

The first column is text. The D is the selected Unit
The formula under the D is =INDEX(B2:F6,1,MATCH(B8,B1:F1))
This is copied down the column
I made a chart using the second area (less the first row)
When I change D to A, I get the data from the A unit column and this get
charted.

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jchick0909" wrote in message
...
is there a way to create an outline of a graph, similar to the subtotals
function resulting ouline? For example, I have 10 unit numbers each
number
has five different values i want to see, but then hide as I look at the
next
unit number's five values in a bar graph.

Thanks!