Charts in Excel

  • Thread starter Hootenanny
  • Start date
  • #1
Hootenanny
Staff Emeritus
Science Advisor
Gold Member
9,624
8
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
Insights Author
Gold Member
2,569
721
Merged cells are a problem when plotting in excel......
 
  • #3
Hootenanny
Staff Emeritus
Science Advisor
Gold Member
9,624
8
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
Insights Author
Gold Member
2,569
721
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,624
8
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:
 

Suggested for: Charts in Excel

  • Last Post
Replies
2
Views
584
  • Last Post
Replies
16
Views
673
Replies
1
Views
504
Replies
13
Views
517
Replies
3
Views
394
  • Last Post
Replies
10
Views
937
  • Last Post
Replies
5
Views
793
  • Last Post
Replies
19
Views
2K
Replies
5
Views
914
Replies
14
Views
1K
Top