Good morning,

I am having a terrible time trying to make this chart work. I can do it in excel with ease but for some reason crystal wont display anything correctly.

I have three lists of data:

Cost	Week	BurnRate
18394	2	17090
5503	3	17090
6459	4	17090
47723	5	17090
102405	6	17090
4238	7	17090
6357	9	17090
7412	10	17090
52645	11	17090
20955	12	17090
31287	13	17090
33396	14	17090
8817	15	17090
2706	16	17090
427	17	17090
27843	18	17090
31524	19	17090
586	20	17090
32270	21	17090
70831	22	17090
7661	23	17090
2450	24	17090
254880	31	17090
436688	44	17090
82392	50	17090
27067	53	17090

In excel it formats perfectly in crystal the axis spikes up to 200 million and the plots are all over the map.

I've picked  line chart, on the data tab I've said on change of week; show values: cost and burn rate, and tried setting the data values and divisions but that screws it up even more.

Any ideas would be most welcome. Because what I ended up doing was turning the excel chart into a bitmap and inserting it into the report.

Thanks

Laura