CiAgICA8IS0tIExpbmtlZEluIC0tPgogICAgPHNjcmlwdCB0eXBlPSJ0ZXh0L2phdmFzY3JpcHQiPgogICAgICAgIF9saW5rZWRpbl9wYXJ0bmVyX2lkID0gIjEyMzUwNzMiOwogICAgICAgIHdpbmRvdy5fbGlua2VkaW5fZGF0YV9wYXJ0bmVyX2lkcyA9IHdpbmRvdy5fbGlua2VkaW5fZGF0YV9wYXJ0bmVyX2lkcyB8fCBbXTsKICAgICAgICB3aW5kb3cuX2xpbmtlZGluX2RhdGFfcGFydG5lcl9pZHMucHVzaChfbGlua2VkaW5fcGFydG5lcl9pZCk7CiAgICA8L3NjcmlwdD48c2NyaXB0IHR5cGU9InRleHQvamF2YXNjcmlwdCI+CiAgICAgICAgKGZ1bmN0aW9uKCl7dmFyIHMgPSBkb2N1bWVudC5nZXRFbGVtZW50c0J5VGFnTmFtZSgic2NyaXB0IilbMF07CiAgICAgICAgICAgIHZhciBiID0gZG9jdW1lbnQuY3JlYXRlRWxlbWVudCgic2NyaXB0Iik7CiAgICAgICAgICAgIGIudHlwZSA9ICJ0ZXh0L2phdmFzY3JpcHQiO2IuYXN5bmMgPSB0cnVlOwogICAgICAgICAgICBiLnNyYyA9ICJodHRwczovL3NuYXAubGljZG4uY29tL2xpLmxtcy1hbmFseXRpY3MvaW5zaWdodC5taW4uanMiOwogICAgICAgICAgICBzLnBhcmVudE5vZGUuaW5zZXJ0QmVmb3JlKGIsIHMpO30pKCk7CiAgICA8L3NjcmlwdD4KICAgIDxub3NjcmlwdD4KICAgICAgICA8aW1nIGhlaWdodD0iMSIgd2lkdGg9IjEiIHN0eWxlPSJkaXNwbGF5Om5vbmU7IiBhbHQ9IiIgc3JjPSJodHRwczovL3B4LmFkcy5saW5rZWRpbi5jb20vY29sbGVjdC8/cGlkPTEyMzUwNzMmZm10PWdpZiIgLz4KICAgIDwvbm9zY3JpcHQ+CiAgICA8IS0tIEVuZCBMaW5rZWRJbiAtLT4KICAgIA==
Generic filters
Exact matches only
Search in title
Search in excerpt
Search in content

Bissantz'Numbers Add-In für Excel

Mit unserem kostenlosen Add-in für Microsoft Excel erstellen Sie typografisch skalierte Zahlen im Handumdrehen: Zellen markieren, Schaltfläche „Zahlen skalieren“ anklicken – fertig!

Das Add-in erzeugt die typografische Skalierung dynamisch: Die Darstellung aktualisiert sich automatisch, sobald sich die Daten ändern. Sie können mehrere Zellbereiche mit eigener Skalierung definieren, zum Beispiel für absolute und relative Werte (Prozentwerte). Zwei weitere Darstellungsoptionen stehen zur Verfügung: Die kompakte Formatierung von Zahlen in „Tsd.“, „Mio.“ und „Mrd.“ verbessert die Lesbarkeit der Tabelle, die automatische Färbung der Werte in Abstufungen von Rot und Blau („Business Colors“) oder Grau verleiht den Zahlen eine Signalwirkung. Das Anzeigen und Drucken von Bissantz’Numbers ist auch ohne installiertes Add-in möglich; dieses wird nur bei Änderungen benötigt.

Systemvoraussetzungen: Microsoft Excel für Windows, Version 2010, 2013 oder 2016; Microsoft .NET Framework 4.0 oder höher (in der Regel bereits installiert, in Windows 8 und 10 Bestandteil von Windows).

Bissantz Bild

Bissantz’Numbers-Excel-Add-in anfordern

ICAgICAgICA8aW5wdXQgdHlwZT0iaGlkZGVuIiBuYW1lPSJmcm9tIgogICAgICAgICAgICAgICB2YWx1ZT0iaHR0cHM6Ly93d3cuYmlzc2FudHouZGUvbmV3cy93aXNzZW4vYmlzc2FudHpudW1iZXJzLWFkZC1pbi8iPgogICAgICAgIDxpbnB1dCB0eXBlPSJoaWRkZW4iIG5hbWU9InJlY2FwdGNoYV9yZXNwb25zZSIgaWQ9InJlY2FwdGNoYVJlc3BvbnNlIj4KCgkJPHNjcmlwdCBzcmM9Ii8vd3d3Lmdvb2dsZS5jb20vcmVjYXB0Y2hhL2FwaS5qcz9yZW5kZXI9NkxjeGU4TVVBQUFBQUZjRGEwejd3aENacksxUFlwQjlTN1pqLUtSYSZvbmxvYWQ9cmVjYXB0Y2hhT25sb2FkIj48L3NjcmlwdD4KCQk8c2NyaXB0PgogICAgICAgICAgICB2YXIgYmlzc1JlY2FwdGNoYSA9IHsKICAgICAgICAgICAgICAgIGZvcm1TZWxlY3RvcjogbnVsbCwKICAgICAgICAgICAgICAgIHN1Ym1pdEJ1dHRvbjogbnVsbCwKCiAgICAgICAgICAgICAgICBnZXRQYWdlVG9rZW4oc3VibWl0KSB7CgogICAgICAgICAgICAgICAgICAgIC8vIFN0b3JlIGEgcmVmZXJlbmNlIHRvIHRoZSBjdXJyZW50IHNjb3BlCiAgICAgICAgICAgICAgICAgICAgdmFyIHRoYXQgPSB0aGlzOwoKICAgICAgICAgICAgICAgICAgICAvLyBDaGVjayBpZiB0aGUgZm9ybSBzaG91bGQgYmUgc3VibWl0dGVkIGFzIHdlbGwKICAgICAgICAgICAgICAgICAgICBpZiAodHlwZW9mIHN1Ym1pdCA9PT0gJ2Jvb2xlYW4nICYmIHN1Ym1pdCA9PT0gdHJ1ZSkgewoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gU3RvcmUgdGhlIHN1Ym1pdCBidXR0b24KICAgICAgICAgICAgICAgICAgICAgICAgdGhpcy5zdWJtaXRCdXR0b24gPSBkb2N1bWVudC5xdWVyeVNlbGVjdG9yKCcjc2MtMzg4NzIgZm9ybSBbdHlwZT0ic3VibWl0Il0nKTsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIERpc2FibGUgdGhlIGJ1dHRvbgogICAgICAgICAgICAgICAgICAgICAgICB0aGlzLnN1Ym1pdEJ1dHRvbi5jbGFzc05hbWUgKz0gJyBidXR0b24tLWRpc2FibGVkJzsKICAgICAgICAgICAgICAgICAgICB9CgogICAgICAgICAgICAgICAgICAgIC8vIEV4ZWN0dWUgdGhlIHJlY2FwdGNoYSBjYWxsCiAgICAgICAgICAgICAgICAgICAgZ3JlY2FwdGNoYS5leGVjdXRlKCc2TGN4ZThNVUFBQUFBRmNEYTB6N3doQ1pySzFQWXBCOVM3WmotS1JhJywge2FjdGlvbjogJ0FubWVsZHVuZ19CaXNzYW50ek51bWJlcnNfRXhjZWxBZGRpbl9ERV8nfSkudGhlbihmdW5jdGlvbih0b2tlbikgewoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gU2V0IHRoZSByZWNhcHRjaGEgdG9rZW4KICAgICAgICAgICAgICAgICAgICAgICAgZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQoJ3JlY2FwdGNoYVJlc3BvbnNlJykudmFsdWUgPSB0b2tlbjsKCiAgICAgICAgICAgICAgICAgICAgICAgIC8vIENoZWNrIGlmIHRoZSBmb3JtIHNob3VsZCBiZSBzdWJtaXR0ZWQgYXMgd2VsbAogICAgICAgICAgICAgICAgICAgICAgICBpZiAodHlwZW9mIHN1Ym1pdCA9PT0gJ2Jvb2xlYW4nICYmIHN1Ym1pdCA9PT0gdHJ1ZSkgewoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIFJlLWVuYWJsZSB0aGUgYnV0dG9uCiAgICAgICAgICAgICAgICAgICAgICAgICAgICB0aGF0LnN1Ym1pdEJ1dHRvbi5jbGFzc05hbWUucmVwbGFjZSgnYnV0dG9uLS1kaXNhYmxlZCcsICcnKTsKCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAvLyBTdWJtaXQgdGhlIGZvcm0KICAgICAgICAgICAgICAgICAgICAgICAgICAgIHRoYXQuZm9ybVNlbGVjdG9yLnN1Ym1pdCgpOwogICAgICAgICAgICAgICAgICAgICAgICB9CiAgICAgICAgICAgICAgICAgICAgfSk7CiAgICAgICAgICAgICAgICB9LAoKICAgICAgICAgICAgICAgIGdldFBhZ2VUb2tlblByb21pc2VkKCkgewoKICAgICAgICAgICAgICAgICAgICAvLyBFeGVjdHVlIHRoZSByZWNhcHRjaGEgY2FsbAogICAgICAgICAgICAgICAgICAgIHJldHVybiBncmVjYXB0Y2hhLmV4ZWN1dGUoJzZMY3hlOE1VQUFBQUFGY0RhMHo3d2hDWnJLMVBZcEI5Uzdaai1LUmEnLCB7YWN0aW9uOiAnQW5tZWxkdW5nX0Jpc3NhbnR6TnVtYmVyc19FeGNlbEFkZGluX0RFXyd9KTsKICAgICAgICAgICAgICAgIH0sCgogICAgICAgICAgICAgICAgYmluZGluZygpIHsKCiAgICAgICAgICAgICAgICAgICAgLy8gU3RvcmUgYSByZWZlcmVuY2UgdG8gdGhlIGN1cnJlbnQgc2NvcGUKICAgICAgICAgICAgICAgICAgICB2YXIgdGhhdCA9IHRoaXM7CgogICAgICAgICAgICAgICAgICAgIC8vIEFkZCB0aGUgZm9ybSBsaXN0ZW5lcgogICAgICAgICAgICAgICAgICAgIHRoaXMuZm9ybVNlbGVjdG9yLmFkZEV2ZW50TGlzdGVuZXIoJ3N1Ym1pdCcsIGZ1bmN0aW9uKGV2ZW50KSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBQcmV2ZW50IHRoZSBzdWJtaXQgcHJvY2VzcwogICAgICAgICAgICAgICAgICAgICAgICBldmVudC5wcmV2ZW50RGVmYXVsdCgpOwoKICAgICAgICAgICAgICAgICAgICAgICAgLy8gR2V0IHRoZSBwYWdlIGtleSBhbmQgc3RvcmUgaXQKICAgICAgICAgICAgICAgICAgICAgICAgdGhhdC5nZXRQYWdlVG9rZW4odHJ1ZSk7CiAgICAgICAgICAgICAgICAgICAgfSwgZmFsc2UpOwogICAgICAgICAgICAgICAgfSwKCiAgICAgICAgICAgICAgICBpbml0KCkgewogICAgICAgICAgICAgICAgICAgIC8vIFN0b3JlIGZvcm0gc2VsZWN0b3JzCiAgICAgICAgICAgICAgICAgICAgdGhpcy5mb3JtU2VsZWN0b3IgPSBkb2N1bWVudC5xdWVyeVNlbGVjdG9yKCcjc2MtMzg4NzIgZm9ybScpOwoKICAgICAgICAgICAgICAgICAgICAvLyBNYWtlIHN1cmUgdGhlIGZvcm0gc2VsZWN0b3IgZXhpc3RzCiAgICAgICAgICAgICAgICAgICAgaWYgKHRoaXMuZm9ybVNlbGVjdG9yICE9PSBudWxsKSB7CgogICAgICAgICAgICAgICAgICAgICAgICAvLyBCaW5kIHRoZSBzdWJtaXQgZXZlbnQKICAgICAgICAgICAgICAgICAgICAgICAgdGhpcy5iaW5kaW5nKCk7CiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgfSwKCiAgICAgICAgICAgICAgICByZWNhcHRjaGFIYW5kbGVyKCkgewogICAgICAgICAgICAgICAgICAgIC8vIElmIHJlY2FwdGNoYSBpcyBkZWZpbmVkCiAgICAgICAgICAgICAgICAgICAgaWYgKHR5cGVvZiBncmVjYXB0Y2hhICE9PSAndW5kZWZpbmVkJykgewogICAgICAgICAgICAgICAgICAgICAgICBncmVjYXB0Y2hhLnJlYWR5KGZ1bmN0aW9uKCkgewoKICAgICAgICAgICAgICAgICAgICAgICAgICAgIC8vIEluaXRpYWxpemUgcmVjYXB0Y2hhCiAgICAgICAgICAgICAgICAgICAgICAgICAgICBiaXNzUmVjYXB0Y2hhLmluaXQoKTsKCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAvLyBJbml0aWFsbHkgdHJ5IHRvIGdldCB0aGUgcGFnZSBrZXkKICAgICAgICAgICAgICAgICAgICAgICAgICAgIGJpc3NSZWNhcHRjaGEuZ2V0UGFnZVRva2VuKCk7CiAgICAgICAgICAgICAgICAgICAgICAgIH0pOwogICAgICAgICAgICAgICAgICAgIH0KICAgICAgICAgICAgICAgIH0sCiAgICAgICAgICAgIH07CgogICAgICAgICAgICBmdW5jdGlvbiByZWNhcHRjaGFPbmxvYWQoKSB7CiAgICAgICAgICAgICAgICBiaXNzUmVjYXB0Y2hhLnJlY2FwdGNoYUhhbmRsZXIoKTsKICAgICAgICAgICAgfQogICAgICAgIDwvc2NyaXB0PgoJCQ==





* Pflichtangaben

Diese Seite ist durch reCAPTCHA von Google geschützt. Es gelten die Datenschutzrichtlinien und Nutzungsbedingungen von Google.








PGJyIC8+CjxidXR0b24gY2xhc3M9ImJ1dHRvbiBidXR0b24tLWZpbGxlZCBidXR0b24tLWNvbG9yLXByaW1hcnkiIHR5cGU9InN1Ym1pdCI+QW5mb3JkZXJuPC9idXR0b24+PGJyIC8+Cg==

All rights reserved by Bissantz & Company GmbH, 2019. Registered Design. German, European and US-patents pending.
DeltaMaster, Bissantz’Numbers, Sparknumbers, Sparkfonts, Sparkticker and other Bissantz products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Bissantz.
Graphics and animations: Olaf Böhme, Bissantz, Studio F. A. Porsche, Infographics group

Nicolas Bissantz

Diagramme im Management

Besser entscheiden mit der richtigen Visualisierung von Daten

Erhältlich überall, wo es Bücher gibt, und im Haufe-Onlineshop.