CREATING GRAPHS

[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

 

[Andy Pope]

Hi Mohammad,

Check out Jon's examples of using dynamic ranges.
http://peltiertech.com/Excel/Charts/Dynamics.html

Cheers
Andy

 

[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

 

[Mohammad Mian]

Andy, thank you for your prompt response. You are a life saver.

 

[Mohammad Mian]

Thank you Tom, you are really a life saver.