bellissimo hack per excel, grazie a http://lifehacker.com

Non sostituisce la funzione del grafico, ma in molte occasioni e' quello che serve!

Attenzione che in italiano la funzione REPT e' RIPETI

Excel tip: Instant in-cell graphs

The Juice Analytics blog has a clever little Excel trick that creates a bar graph inside cells using the repeat (REPT) function.

REPT (in italiano RIPETI) looks like this:
=REPT(text,number_of_times)
For instance, REPT("X",10) gives you "XXXXXXXXXX". For in-cell bar charts, the trick is to repeat a single bar "|". When formatted in 8 point Arial font, single bars look like bar graphs.

Commenti

Nuovo Cerca RSS

Commenta
Nome:
Email:
Website:
Titolo:
UBBCode:	-colore-acquaneroblufucsiagrigioverdelimemarronenavyoliveporporarossoargentocelestebiancogiallo -dimensione-micropiccolomediograndeenorme

Powered by !JoomlaComment 3.26

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."