|
Excel Charts
Various Examples
HL Examples
Excel-FAQs
Excel-Hotline
Excel Colors
Excel Grids
Excel Brainteasers
2003 vs. 2007..10
Seminar Topics
Exhibits
HI-CHART Templates
HI-CHART Prototypes
|
HL Examples are what we call the chart templates developed by Uwe Brück for Hochland AG, which we are able to make available to all interested parties in a more neutral form (Mr. Brück has dealt thoroughly with our Excel Tricks and developed these templates independently). These templates, which were developed specifically for Hochland, but which can certainly be applied as general templates, are available for both Excel 97..2003 as well as for Excel 2007.
Below the overview image you will find 20 templates, which can be downloaded as a (non-functioning) demo version. You can download the example H20-22 for both 2003 as well as for 2007 as a full version. We are offering all full versions of these 20 templates (in German) at a price of EUR 100, excl. VAT - either as a 2003 or as 2007 version. You can order right here!
Please be aware that these are not "products" for practical use, rather they are examples for trial and practice, which will need be to be adjusted individual parameters. These adjustments require a good understanding of Excel, for that we recommend attending our seminar series Charts with Excel ahead of time.
|
|
|
|
|
The Excel charts shown to the right cost together EUR 100.
The charts were developed by Uwe Brück using Excel 2007 and Björn Rick rendered more neutral, uniform, and executable for both Excel versions.
|
 |
|
|
|
 |
HL Chart H10-01
2003-Demo
2007-Demo
Here it is possible to freely specify the decimal places (1..3) of the value label.
|
|
|
|
 |
HL Chart H20-13
2003-Demo
2007-Demo
In this chart, the scaling factor is calculated automatically using the MAX value, manual intervention is no longer necessary here.
The IFERROR function is used in the 2007 version. This function is not supported in 2003. In 2003, this must be created using an IF-interleaving.
|
|
|
|
 |
HL Chart H20-21
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H20-22
2003-Demo
2007-Demo
2003-Full version
2007-Full version
|
|
|
|
 |
HL Chart H30-01
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H20-18
2003-Demo
2007-Demo
In 2003 version, the bars are not displayed cleanly here. This is due to the fact that they were developed using 2007 and the "line trick" was applied there.
|
|
|
|
 |
HL Chart H10-02
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H20-20
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H10-07
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H30-03
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H10-03
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H20-01
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H20-19
2003-Demo
2007-Demo
In the 2007 version, the IFERROR function is used. This function is not supported by 2003 since it is no longer included. In 2003, this must be created using an IF-interleaving.
|
|
|
|
 |
HL Chart H21-06
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H20-11
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H10-06
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H40-03
2003-Demo
2007-Demo
|
|
|
|
 |
HL Chart H20-14
2003-Demo
2007-Demo
In 2003 version, the bars are not displayed cleanly here. This is due to the fact that they were developed using 2007 and the "line trick" was applied there.
|
|
|
|
 |
HL Chart H20-17
2003-Demo
2007-Demo
In 2003 version, the bars are not displayed cleanly here. This is due to the fact that they were developed using 2007 and the "line trick" was applied there.
|
|
|
|
 |
HL Chart H20-07
2003-Demo
2007-Demo
In 2003 version, the bars are not displayed cleanly here. This is due to the fact that they were developed using 2007 and the "line trick" was applied there. |
