Graph with trendline question

[polisasimo]

Hello, I have a column graph with two data sets. Let's say Row 1 represent a month value JAN-JUN. Row two has columns A:F populated with values ranging from 1-10. Row three only has values in columns D:F. When the select data I must include columns A:F for row three or the graph will left justify the columns and April's data for row three will start in January. So I set the select data for the series as row 3 columns A:F which will line the data up with the X axis correctly.

My problem is adding a trend line picks up the NULL values in cells 3A:C. I want to shift the trend lines starting point and ending points for series two to 3C:D.

Or

Right justify series two entirely with only selecting 3C:D.

Any idea's would be great.

thanks in advance.