CREATING GRAPHS

M

Mohammad Mian

Greetings:

I have template that can take 10 data points and then these data points
are plotted. However, at times I may not have all the 10 data points,
i.e. I may have 5 data points, but since the graph ranges through the 10
data points, zeros are plotted for the empty cells.

Is there any way that I can automate the range of the graph so that it
will only plot the cells with data and ignore the empty cells,
especially if the empty cells are the last points in the data range.

Your assistance in this respect will be very highly appreciated.

Thanks and regards




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 
T

Tom Ogilvy

use a defined name

Insert=>Name=>Define
Name:= DataSource
RefersTo: =Offset(Sheet1!$A$1,0,0,Count(Sheet1!$A$1:$A$10),2)

then for the source of your graph put in

=MyWorkbook.xls!DataSource
 
Top