A | B | C | D | E | F | G | H | I | |
1 | id# | Mth 1 | Mth 2 | Mth 3 | Mth 4 | Mth 5 | Mth 6 | Mth 7 | Mth 8 |
2 | 19 | $100 | $200 | $150 | $325 | $175 | $250 | $200 | $300 |
3 | 27 | $150 | $125 | $175 | $225 | $300 | $375 | $400 | $325 |
4 | 57 | $75 | $150 | $275 | $250 | $325 | $325 | $400 | $425 |
<tbody>
</tbody>
On sheet one I look up ID# "27" I need the sparkline to use the values "150,125,175,225,300,375,400,325". This table is just an example. the real source data is 14 columns wide and almost 12,000 rows. And I need to create sparklines for all 12,000 rows.
Help.