Hide Trend Line

[IAMDV]

I have monthly trend chart with complex expression. I need help in hiding the line in the chart when there is no data available. For example if I have following data...

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Month Sales

Jan 1002

Feb 3852

Mar 2087

Apr 5275

May NULL

Jun NULL

Jul 2582

Aug 1853

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Now I wanted to hide or break the line in the chart for May & Jun as the data is not available. And I wanted to continue with the trend line from July. I hope this makes sense!

Thanks in advance.

Cheers - DV

[#2 · Accepted solution]

Attached QVW. Best answer I know of. All instructions in text box in QVW.

[IAMDV]

Awesome! Thanks so much...