Note: The Green Actual trendline drops to zero in May-Dec....I want to limit the actual trendline to show only data to date.
Hi Sean Harrison, try this in the windows client - Chart, Chart Options, Global Options, Hide Zeros:
You'll probably need to exit edit mode and refresh the chart to see the change.
Worked like a charm!! Thanks for the quick reply!!
No problem, happy to help.
Retrieving data ...