Incell charts

[GODZILLA]

Hello,


I have a series of incel charts working of the REPT("|", A1) A1 having a %*10 to make a chart.


I need a performance indicator. I tryed adding a line where 100% was over the incell bars. However when you print preview the Incell look different in Print preview then in the dashboard.


The bars are smaller so it appears that my dataset is not performing well enough.


Any ideas what i can do to stop this?


I am using Script font type.


Thanks

 

[Hui]

Change to a more proportional font

Try Swiss, Modern or Roman

 

[GODZILLA]

That doesnt seem to change much.


If I use Webdings rept("g",A1) it works better but the size of the blocks is too large.


My intention is to create a solid bar btw.


Can you recomend a different option?


Thanks

 

[dan_l]

I've got a post around somewhere with formula for a text based bulletchart. It wasn't very good, but perhaps it will give you some ideas?

 

[Hui]

Godzilla

Also type Incell Chart into the Google Custom Search window up the top of this page

The first 4/5 articles are all worth reading

 

[GODZILLA]

Thanks guys i will have a look through.


Thanks again.