Excel 2007 Line Chart overlapping different values (1 Viewer)

[noboffinme]

Hi

I wonder if anyone has had this issue, I have a table with 5 Columns, 4 formatted as Currency & 1 as %, the values for the Currency are vastly different in each category but when I chart them, they overlap the previous values??

I've tried changing the Format back to General, no luck.

I tried another PC to see if it was the PC but no luck either.

I've never had this problem before, any suggests??

Thanks

 

[noboffinme]

Mysteriously, I was able to right click on the legend names, select a different chart type & get it to chart correctly.

Must be a glitch or something.

I'll see if repairing Excel helps.