Charts in Excel

  • Thread starter Hootenanny
  • Start date
  • #1
Hootenanny
Staff Emeritus
Science Advisor
Gold Member
9,622
6

Main Question or Discussion Point

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.
 

Answers and Replies

  • #2
Dr Transport
Science Advisor
Gold Member
2,390
519
Merged cells are a problem when plotting in excel......
 
  • #3
Hootenanny
Staff Emeritus
Science Advisor
Gold Member
9,622
6
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?
 
  • #4
Dr Transport
Science Advisor
Gold Member
2,390
519
Could be, they get truncated on the tab if you have a long filename when you import.
 
  • #5
Hootenanny
Staff Emeritus
Science Advisor
Gold Member
9,622
6
Dr Transport said:
Could be, they get truncated on the tab if you have a long filename when you import.
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:
 

Related Threads on Charts in Excel

  • Last Post
Replies
4
Views
3K
  • Last Post
Replies
7
Views
26K
  • Last Post
Replies
19
Views
2K
  • Last Post
Replies
1
Views
5K
  • Last Post
Replies
4
Views
852
  • Last Post
Replies
3
Views
64K
  • Last Post
Replies
2
Views
9K
  • Last Post
Replies
2
Views
7K
  • Last Post
Replies
3
Views
2K
  • Last Post
Replies
3
Views
2K
Top