Hichert Partner Logo

Deutsch (DE-CH-AT)

Consulting > ExhibitsHI-CHART TEMplates '10

Excel Charts

Various Examples

Excel Book

Excel Templates

Excel Seminar

Excel FAQs 

Excel Hotline

Excel Colors

Excel Grid

Excel Brainteasers

Excel Tutorial (German)

2003 vs. 2007

Seminar Topics

 

Excel Templates

HI-CHART Templates '12

HI-CHART Templates '10

HI-CHART Templates '08

HI-CHART Templates '07

 

 

 

HI-CHART Templates '10 - the previous generation

We present the 2010 generation of complex Master Templates, developed entirely using Excel for creating sophisticated charts.


HI-CHART Templates '12 - the current generation

HI-CHART Templates '08 - the second generation

HI-CHART Templates '07 - the first generation

 

 

Stacked waterfall with zoom
The newest development from Holger Gerths fulfills long-standing wishes for visualization.
The stack should only be used with restraint, it is not appropriate for every application. A stack with different  signs is particularly challenging.
Here a large picture is available for download.

 

 

 

Master Template M_02v

Higher resolution available for download:
1024 pixels wide
1592 pixels wide

 

It is quite impressive what Excel is capable of when pushed to the limit...

(Here as well without any programming, no macros)

 

 

 

 

Column Waterfall

Click here for download

 

This example is taken from the seminar "Excel Charts 4" by Holger Gerths.

More…

 

 

 

 

Master Template M_01v
(no download available)

 

 

   

Master Template M_02v with zoom

(no download available)


Such visualizations are increasingly proving their worth – one of the few ways to uphold the SUCCESS Rule 4.4 (correct scaling).

 

(It was no easy matter to achieve this purely using Excel, Holger Gerths had to pull out all the stops here...)

 

 

   

Master Template M_01h

(no download available)

 

The stacked column chart is a classic – but a bit special here with scaling bars and highlighting.

 

   

Master Template M_02v

to download click here

 

Here you can get an idea of how the Master Templates developed by Holger Gerths are constructed (many functions are hidden).

 

 

 

   

Master Template M_02h

(no download available)

 

This column waterfall is also a classic. One special feature is the automatic application of our Rules of Notation such as 2.2.6.

 

 

 

 

 

B   New menu configurator for any templates

With the new menu configurator, our Master Templates can be used conveniently. This would otherwise be impossible for templates with a hundred or more parameters. The configurator is an add-in, which can be designed by the user. We would be happy to advise customers of our master templates on how to use these tools – please contact us here.

 

Menu configurator
Download the movie here (wmv file with 1.7 MB)