Skip to Content
0
Former Member
Mar 05, 2009 at 12:35 AM

Trend Analyzer Plotting Zeros (0)

22 Views

Hi,

I have a simple combo chart plotting sales figures, I wanted to add a simple Trend line using Trend Anlyzer. I add another series to my chart to point it to the Trend results cells. When I preview, the Trend Results Cells are all populated with Zero's - Really weird since my avg sales are approx $200k per day.

Is this because my Sales data cells contain vlookup formulas ?

Any help is greatly appreciated.