Tech Support Guy banner
Status
Not open for further replies.
1 - 6 of 6 Posts

·
Registered
Joined
·
378 Posts
Discussion Starter · #1 ·
Let's say I have datas from a1 to a100. The other cells in column a are empty.
If I clic "insert" "chart" and "finish" Excel create a nice chart and detect automaticaly the filled cells and forget the empty cells.


Now is it possible to ask Excell to automaticaly extent the range if I add more datas in empty cells?

For example, if after creating the chart with only a1 to a100 filled, I enter datas in cells a101 to a150, the chart will display the datas from a1 to a150. is it a way to do this?
 

·
Registered
Joined
·
2,702 Posts
Charts -- not something I have much to do with. Try this. Define a dynamic named range as follows ;

CTRL+F3
Name = "Data" (without the quotes)
Refers to:

=OFFSET(Sheet1!$A$1,,,COUNTA(Sheet1!$A:$A),1)

Create chart, under Step 2, go to the Series tab, set Values as

=Sheet1!Data

Top & tail as required. The resultant chart should shrink & grow as you remove or add data in A:A.

HTH,
Andy
 

·
Registered
Joined
·
2,702 Posts
>> You can modify the chart by changing the cell range ...

Sure can, but I doubt this constitutes "automaticaly extent (sic) the range".

Rgds,
Andy
 

·
Registered
Joined
·
11,755 Posts
Fred:

All you need to do is select those new cells.
Copy them.
Click on your chart.
Hit paste.
That's right...paste while you have the chart selected.
Pretty darn simple, right?
 

·
Registered
Joined
·
2,702 Posts
Fred,

You can even select those new cells and drag'n'drop them onto the chart. Even simpler, but still not automatic.

Rgds,
Andy
 
1 - 6 of 6 Posts
Status
Not open for further replies.
Top