cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Submit your abstract to the call for content for Discovery Summit Americas by April 23. Selected abstracts will be presented at Discovery Summit, Oct. 21- 24.
Discovery is online this week, April 16 and 18. Join us for these exciting interactive sessions.
jorgeramosdealm
Level III

Heat Map box customization

Does anyone know how to change the size of the boxes from a heat map?

2277_heatmap.png

File is in attachment.

1 REPLY 1
XanGregg
Staff

Re: Heat Map box customization

I think the sizes are based on the default histogram binning, which is largely based on the number of rows. I'm afraid I don't see a way to override that. Summarizing the data so that there are fewer rows may help. For example,

  1. use Distribution to make histograms of those two columns
  2. adjust the bins
  3. Save Level Midpoints for each histogram
  4. Table > Summary by the two midpoint columns, which produces a new table with those two columns plus an N Rows column.
  5. Graph the two variables as X and Y and put N Rows in the Freq column.

If you find binning that works, you'll probably want to edit the last germline midpoint so it is less than 1 so those values don't spill into the next cell.