Hi all

Whenever I try to plot an XY Scatter Graph where the x-axis is Time related and the result of a formula the graph doesn't display correctly. Instead of using the time formatted field as specified, it just numbers the data points sequentially on the x-axis. When I hover the cursor over a data point, I see ' "12/11/12 06:00" (1,550) ' instead of ' "12/11/12 06:00" (12/11/12 06:00,550) '.

Investigation has resulted in the discovery that, if I cut the data and paste the values only and remove all as yet unused formulas from the rest of the data range, the graph displays correctly. This leads me to believe that the formulas are the problem. Most are 'lookup' formulas but have even tried simple copy data from another cell formulas (=b2) but if the original data is the result of a formula ('lookup'), the result is the same.

I wish to create dynamic graphs that change as new data is added and this problem is preventing this.



Any help anyone can give is appreciated.

Thanks