draw different weight lines depending on the cell value

[Guest]

I want to draw different weight lines in a cell based on the value of another
cell. This is to draw a bird abundance chart for a particular location,
similar to many of the seasonal checklists that are published.

 

[Debra Dalgleish]

Maybe you could use one of the in-cell charting techniques that Jon
Peltier describes here:

http://www.peltiertech.com/Excel/Charts/InCellFormulaCharts.html