Chart Area Question

[kreepa]

I am making a SLA dashboard. I want to have a top ten metrics section. I don't want ten charts showing at one time. Instead, is it possiple to have a set area such as G37 to L46 display a different graph depending on which top ten metric you click or hover with your mouse. Any suggestions would be useful.

 

[dave3009]

Hi There

You could use Named Ranges and perhaps VLOOKUP to change the data set. It is possible using both or either to change the data set that a chart look at.

Not sure how you make this method work with 'hovering' but certainly Data Validation can be used

HTH


Dave

 

[kreepa]

Thanks Dave for the reply. How would I use your method?

You mentioned:

You could use Named Ranges and perhaps VLOOKUP to change the data set. It is possible using both or either to change the data set that a chart look at.

Not sure how you make this method work with 'hovering' but certainly Data Validation can be used

PLease Explain.

 

[dave3009]

OK for VLOOKUP try this

Book1
	A	B	C	D	E	F	G	H	I
1	Criteria	Range1	Range2	Range3
2	A	1	2	3
3	B	3	2	1
4	C	4	5	6
5	D	6	5	4
6	E	9	9	9
7
8
9	Column	2	3	4
10	B	3	2	1
11
Sheet1

There is Data Validation in A10 which I use a drop down to select. I make a chart using data from A10 to D10 when the Validation changes the chart changes

Does this move you forward?

KR

Dave