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!

Hi Mohammad,

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

Cheers
Andy

Mohammad Mian wrote:

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!

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

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


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

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

--
Regards,
Tom Ogilvy


"Mohammad Mian" wrote in message
...

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!

Thank you Tom, you are really a life saver.


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