BookmarkSubscribeRSS Feed
jorgeramosdealm

Community Trekker

Joined:

Feb 20, 2012

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
XanGregg

Staff

Joined:

Jun 23, 2011

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.