How do I set up a Chart in Excel with variable cell length?
 

On a result of a formula, the number of cells used can vary, how can I creat
a chart whose series length vary with the results?

Can this be done in VBA?

How do I set up a Chart in Excel with variable cell length?
 

Hi,

Can be done with named ranges. Here are some links including a page of
further links.

http://peltiertech.com/Excel/Charts/Dynamics.html
http://tushar-mehta.com/excel/newsgr...rts/index.html
http://peltiertech.com/Excel/Charts/...hartLinks.html

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Kev" wrote in message
...
On a result of a formula, the number of cells used can vary, how can I
creat
a chart whose series length vary with the results?

Can this be done in VBA?