Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Oct 2005
    Location
    Calgary, Alberta
    Posts
    205
    Thanks
    0
    Thanked 1 Time in 1 Post

    Excel Charts and Data in 07 (2007)

    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?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Excel Charts and Data in 07 (2007)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •