Subscribe Bookmark RSS Feed

Heat Map box customization

jorgeramosdealm

Community Trekker

Joined:

Feb 20, 2012

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

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.