Choose Language Hide Translation Bar
Community Trekker

Heat Map box customization

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


File is in attachment.

0 Kudos

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.

0 Kudos