1. Not finding help here? Sign up for a free 30min tutor trial with Chegg Tutors
    Dismiss Notice
Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Charts in Excel

  1. Mar 11, 2006 #1

    Hootenanny

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    I am trying to do a scatter plot in Excel, and I am referencing points from a different sheet. However, excel won't let me reference more than eight cells. Some of the cells are merged, I don't know if that will affect it...

    Any help would be appreciated.
     
  2. jcsd
  3. Mar 11, 2006 #2

    Dr Transport

    User Avatar
    Science Advisor
    Gold Member

    Merged cells are a problem when plotting in excel......
     
  4. Mar 12, 2006 #3

    Hootenanny

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    Thank's for the suggestion, I tried un merging the cells, and just referencing the single cells, however, the same problem occured. I have rather long sheet names, do you think that may have something to do with it?
     
  5. Mar 12, 2006 #4

    Dr Transport

    User Avatar
    Science Advisor
    Gold Member

    Could be, they get truncated on the tab if you have a long filename when you import.
     
  6. Mar 17, 2006 #5

    Hootenanny

    User Avatar
    Staff Emeritus
    Science Advisor
    Gold Member

    I changed the tab name to a shorter name and found that the chart was plotted perfectly, even with the merged cells. Thank's very much for your help :smile:
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Have something to add?



Similar Discussions: Charts in Excel
  1. Histograms in Excel (Replies: 4)

  2. Excel summing (Replies: 3)

  3. Excel + Calculations (Replies: 9)

Loading...