How to make a flexible line chart in Excel

**BNCOXUK** · 10-30-2012, 11:31 AM

Hello everyone,

I have a question about how to make a flexible line chart. Based on the value of cell A1, column B is dynamic with its values changed. For example, if A1=1, then column will have 100 rows with value, but when A1=0, then only 50 rows in column B have value.

thanks for help.

**Jacc** · 10-30-2012, 11:42 AM

You can use dynamic named ranges.
http://support.microsoft.com/kb/830287

**BNCOXUK** · 10-30-2012, 12:01 PM

Thanks a lot for your help, Jacc.

**Jacc** · 10-30-2012, 12:26 PM

You are velcome!

I see that you are on Excel 2003 but since that might not last forever I want to point out that in newer versions of Excel there is a feature called a Table (under the Insert tab). What this does is to create it's own dynamic named ranges. They need to be referenced slightly different but works like a charm.
http://www.jkp-ads.com/articles/Excel2007tables.asp