Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 29 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 32 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::load() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 161 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 138 Strict Standards: Non-static method JRequest::clean() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 33 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 463 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 464 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 465 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 466 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 467 Strict Standards: Non-static method JRequest::_cleanArray() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/environment/request.php on line 468 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 35 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 38 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 39 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::load() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 161 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 138 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 46 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 47 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 50 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 53 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::import() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 54 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/loader.php on line 71 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 57 Strict Standards: Non-static method JLoader::register() should not be called statically in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php on line 58 Warning: session_start(): Cannot send session cookie - headers already sent by (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 423 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 423 Warning: Cannot modify header information - headers already sent by (output started at /customers/2/1/8/versin.be/httpd.www/libraries/joomla/import.php:29) in /customers/2/1/8/versin.be/httpd.www/libraries/joomla/session/session.php on line 426 Kleurrijke statistieken Excel 2007/2010
Notice: Use of undefined constant add_css - assumed 'add_css' in /customers/2/1/8/versin.be/httpd.www/plugins/content/sexybookmarks.php on line 49 Notice: Undefined variable: add_class in /customers/2/1/8/versin.be/httpd.www/plugins/content/sexybookmarks.php on line 234

Kleurrijke statistieken Excel 2007/2010

Tijd om op het einde van het jaar je statistieken in een mooi jasje te stoppen, Excel 2007 en 2010
hebben leuke tools, om van die saaie cijfertjes een kleurrijk schouwspel te maken in no time

Open een excel document met een reeks cijfers (of vul een reeks cijfers in). Klik op de werkbalk op voorwaardelijke opmaak (Home/Start). Kies één van de opties Gegevensbalken (staafdiagram in cel), Kleurenschalen (gelijkaardige kleuren voor gelijkaardige waardes) of pictogrammen (iconen).

Je kan de opmaakregels zelf bewerken, de voorwaarden staan standaard op volgende schalen:
dubbele reeks: 50% - 100%
3 waarden of iconen: 33% - 66% - 100%
4 waarden of iconen: 25% - 50% - 75% of 100%

Gelukkig kan je deze regels aanpassen, omdat buitensporig hoge waarden in een cel je statistiek behoorlijk negatief kan inkleuren.

Klik daarom bij Gegevensbalken, Kleurenschema of Pictogramseries op Meer regels



Je kan de waarden hier aanpassen, alsook het Type. Je gebruikt voor een tabel met uitschieters beter het Type getal. Je kan ook een excel Formule gebruiken (bv getal gedeeld door, vermenigvuldigd met...), de procenten (standaard) of een percentiel

 

 

Bureaublad achtergrond afbeeldingen

Laatste

Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_latestnews/helper.php on line 109

Topbedrijven

Vochtbestrijdingsbedrijf Tibas bvba

Meest bezocht

Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79 Warning: Creating default object from empty value in /customers/2/1/8/versin.be/httpd.www/modules/mod_mostread/helper.php on line 79