Excel Charts and Data in 07 (2007)

Topic

New Reply

Hi Lounge,

Just wondering if and one has problems with the scatter plot when you are tryin to plot about 30,000 points, My graph seems to bogg excel down if I try to format the scals ect. If so any ideas on a fix?

Reply | Quote

Replies

I can not test in XL2007, but I don’t see any issues with XL2002.

Note there is a limit of 32,000 pairs of pts for a series in XL2002 (though this may have been changed in XL2007).

If you have lots of formulas (especially array formulas) your spreadsheet may be sluggish in its calculations. Do you have the same problem if you turn the calculation to manual?

Steve

Reply | Quote