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.