Chart empty values

Are you saying you don't want to chart Apr - Sep as there is no data or simple you don't want a line dropping off to zero.

If you don't want the points to show up if there isn't any data, then look into dynamic charts.

If you are still having troubles, how about posting a small sample workbook so nobody has to recreate your data.

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

You will have to setup dynamic ranges to do this. If there are no values the line will drop to zero but there isn't a way to keep that from happening with empty data.

I left the one chart with the sample to follow.

Edit:

Sorry, completely forgot that you can use NA() to not plot a line.

Change E7 and to the right to >> =IF(E4="",NA(),(E6/E4))

Do the same for row 19, row 31, and so on

You will then have to update the formula in C7 to >> =AVERAGEIF(E7:P7,">0")