Dynamic Charting - Scatter Chart - X-axis doesn't display correct reference

Hi all,

I have a chart that I would like to update automatically based on modifications to a series of data on other sheets. I have it so it updates but the x-axis has reverted to an incorrect number scale and I can't seem to fix it.

I've isolated the problem to be something to do with my statement involving an iferror setting unused cells to "". This corrupts the X-axis. However if you remove this statement it then corrupts the graph by making it end at 0,0 which I don’t want either.

Any help on the issue would be great.

Cheers

Linc

Ps. I've attached a sample of the spread sheet for your review. It contains two sheets, iferror error with the incorrect x-axis and chart error where the chart is plotting to 0,0 on the curve.
Variable distribution curve.xlsm

Hey Andy,

Thanks for the reply. I didn't know about the NA() function. It will help me in a few other areas too.

Cheers

Linc