Graph Source Data

[diego]

I have a cell A1 which consists of value : 'Data'!$A$1:$B$4

I want to create a graph based on that cell. Can I use
indirect for this purpose ?



Thanks

 

[Don Guillett]

Just highlight the range and name it mygraphrng or something
then goto the graph wizard and where it asks for source data type in
sheet12!mygraphrng
modify to suit

 

[diego]

Actually my problem is more complex than that. For example:

No Type Jan Feb Mar
1 A 10 20 30
2 B 40 50 60
3 C 70 80 90
4
5
6

I'd like to make the source data dynamic so when I add 'D'
or get rid of 'C' for example, it still plots only
available types only (in this example, 3 types).


Thanks

 

[diego]

Actually my problem is more complex than that. For example:

No Type Jan Feb Mar
1 A 10 20 30
2 B 40 50 60
3 C 70 80 90
4
5
6

I'd like to make the source data dynamic so when I add 'D'
or get rid of 'C' for example, it still plots only
available types only (in this example, 3 types).


Thanks

 

[diego]

Actually my problem is more complex than that. For example:

No Type Jan Feb Mar
1 A 10 20 30
2 B 40 50 60
3 C 70 80 90
4
5
6

I'd like to make the source data dynamic so when I add 'D'
or get rid of 'C' for example, it still plots only
available types only (in this example, 3 types).


Thanks

 

[Don Guillett]

Then make your defined name dynamic
goto insert>names>define>select a name like graphrng
in the refers to box type in
=offset($A$1,0,0,counta($a:$a),12)
Look in HELP index for information on OFFSET