Stopping horizontal axis if input cells are blank

**JSK** · 02-01-2010, 09:17 AM

Am trying to make a line chart based on a colomn including cells with data and bottom of cells blank based on a formula like IF(D1="","",D1). Want the horisontal axis to stop when the colomn with data reaches the "" cells, but it continuous, and it seems that the line chart interpret the "" as a 0 rather than a blank cell. Is it possible to have the line chart horizontal axis to stop if the data cells are blank?

Regards

**Andy Pope** · 02-01-2010, 09:19 AM

For the line use NA() instead of ""

for the axis you will need to either,
Auto filter and hide those rows not required

Or use Dynamic Named Ranges

**JSK** · 02-01-2010, 09:48 AM

Tks for the first peace of help. What do you mean with dynamic named ranges?

**Andy Pope** · 02-01-2010, 09:49 AM

The are many, many examples of dynamic named ranges on the forum.

Also Jon's site has examples and links.
http://peltiertech.com/Excel/Charts/Dynamics.html