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...