With a percentage in A1

Enter this in B1

=REPT(CHAR(149),A1*CELL("width",B1))


Gord Dibben MS Excel MVP



On Fri, 20 Nov 2009 10:59:03 -0800, Rich
wrote:

I got a request from a user to display dots like a trend graph -- in a cell
adjacent to another cell in a row - for each of several rows. The dots don't
vary too much, and I was thinking I could draw these dots on VBA label
controls and place these labels in the cell for each row. Actually, I'm not
sure if I could draw dots inside of a VBA label control. My other
alternative would be to create a custom label in .Net an add that as a custom
control to Excel. Is there something simpler I could do within Excel before
I go crazy with .Net on this?

Thanks,
Rich