|
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
|
Examples taken from our Excel seminars as well as sponsored examples from our customers are available here to download free of charge. The Excel files can be downloaded by clicking on the images. This section is updated on a regular basis. Sign up for our German Newsletter if you are interested in receiving the newest examples and other news.The majority of the examples were conceived for versions from Excel 97 to 2003, unfortunately a few minor adjustments are still needed for 2007, click here. All examples were created without using macros and without VBA, which is what makes them so appealing...The Tips and Tricks for these are presented in our Excel Charts seminars.
MOST OF THE XLS CHARTS ARE IN GERMAN.
|
|
|
|
 |
Chart 675 (Brainteaser 3)
This is our third chart brainteaser. A practical use for a waterfall with columns of different widths is not yet in sight - but this example is well suited for training purposes... Click on the image to the left to download the Excel file.
|
|
|
|
 |
Chart 671
Participants of our XLS1 seminar should be well familiar with this: The first two-thirds of Day 1 of the seminar is concentrates on this topic. If you you can follow this solution without any trouble then you do not need to attend XLS1, and you can begin right away with XLS2. Here is the link to Excel version 2003, including a short film (in German). |
|
|
|
|
|
Charts 670
Here we present three charts under "670," arranged with the help of the Excel Camera in one PowerPoint template.
Click on the image to the left to download the Excel file. |
|
|
|
 |
Chart 657
This is a variation of 655 and 656 - here without interim results.
Click on the image to the left to download the Excel file.
|
|
|
|
|
|
Chart 656
This horizontal waterfall - horizontal, in the sense that it displays structure and not time - has the a distinctive feature of various interim results as well as an arrow that can be positioned as needed.
Click on the image to the left to download the Excel file.
This solution has not yet been perfected, individual labels are not yet correct!
|
|
|
|
|
|
Chart 655
This horizontal waterfall - horizontal, in the sense that it displays structure and not time - has the a distinctive feature of various interim results as well as an arrow that can be positioned as needed.
Click on the image to the left to download the Excel file.
This solution has not yet been perfected, individual labels are not yet correct!
|
|
|
|
|
|
Chart 650
This cockpit is constructed entirely of Excel camera images. Due to the level of complexity, the calculation time (several seconds) is noticeable. This solution is not "finished," it is only a demo intended to illustrate the use of the Excel camera. Click on the image to the left to download the Excel file. |
|
|
|
|
|
Chart 645 (Brainteaser 2)
Here we present a very special xls solution, developed by Holger Gerths: Portfolios with a "fourth dimension," for example with shares in sales of the contribution margin. Realized entirely without VBA. Click on the image to the left to download the Excel file. Here a short movie pertaining to this. |
|
|
|
|
|
Chart 643
Animating portfolio displays - that's possible as an animated gif or as shown here - as an exception - with the help of a VBA program).
No file available yet for download.
|
|
|
|
 |
Chart 641
With this display trick, seasonal factors can be"magnified," in which the "right" scale is not visible. This is not easy to realize: A portion of the data is magnified in another scaling...
|
|
|
|
|
|
Chart 638
A "classic" display: Differences between the planned figure and that for the previous year are shown - here shifted slightly upwards - in an absolute and percentage display. |
|
|
|
|
|
Chart 637
A "classic" display: Differences between the planned figure and that for the previous year are shown - here shifted slightly to the left - in an absolute and percentage display. |
|
|
|
|
|
Chart 631
Similar to Chart 637 |
|
|
|
|
|
Chart 627
A special display for a specific client - this is intended to show that "basically everything" is possible using our Excel tricks without VBA programming. |
|
|
|
|
|
Chart 623
Normally such arrows are realized using special characters - but here it is achieved with a completely different Trick: Move camera and area... |
|
|
|
|
|
Chart 619
A special display for a specific client - this is intended to show that "basically everything" is possible using our Excel tricks without VBA programming. |
|
|
|
|
|
Chart 618
This chart was realized using the Add-In CHART-ME. The COPY function is a great help in creating such multi-charts. Copying the remaining 29 charts from the first one takes - if the data are available - less than one minute(!). Here is the link to the Excel 2003 version, here as a Movie (in German). Here you can go to the Add-In CHART-ME. |
|
|
|
|
|
Chart 617
This version was replaced on 8/12/2008 with an improved solution.
|
|
|
|
|
|
Chart 612
In this instance, Chart 611 is expanded in which both positive as well as negative changes are displayed next to one another and balanced against one another.
Not exactly easy to realize... |
|
|
|
|
|
Chart 611
In this instance, a few special features are included in scaling, shifting left-right as well as shifting above-below: Give it a try! |
|
|
|
|
|
Chart 610
In this instance, the special feature is found in the rotating text.
This is not an easy task even for more advanced chart experts.
This solution could otherwise also be classified as a classic: the juxtaposition of previous year, actual, budget, and expected values.
Note: The position and rotation of the arrow must be adjusted to the specific needs...
|
|
|
|
|
|
Chart 604
This example is based on a new trick and cannot be comprehended at first glance...
In this instance, the column figures are to be entered from 1 to 36, we have prepared four variations in the following:
4 columns
12 columns
24 columns
36 columns
Caution: If "flickering" occurs during chart setup, then error checking has been activated in the background. Please deactivate it.
|
|
|
|
|
|
Chart 603
This example is based on a new trick and cannot be comprehended at first glance...
In this instance, the column figures are to be entered from 1 to 36, we have prepared four variations in the following:
4 columns
12 columns
24 columns
36 columns
Caution: If "flickering" occurs during chart setup, then error checking has been activated in the background. Please deactivate it.
|
|
|
|
|
|
Chart 602
This example is based on a new trick and cannot be comprehended at first glance...
In this instance, the column figures are to be entered from 1 to 36, we have prepared four variations in the following:
4 columns
12 columns
24 columns
36 columns
Caution: If "flickering" occurs during chart setup, then error checking has been activated in the background. Please deactivate it. |
|
|
|
|
|
Chart 601
This example is based on a new trick and cannot be comprehended at first glance...
In this instance, the column figures are to be entered from 1 to 36, we have prepared four variations in the following:
4 columns
12 columns
24 columns
36 columns
Caution: If "flickering" occurs during chart setup, then error checking has been activated in the background. Please deactivate it.
|
|
|
|
|
|
Chart 541
...corresponds with Chart 540, only with less columns.
|
|
|
|
|
|
Chart 540
Yet another variation on this theme. In this instance, several special tricks regarding axis form and visibilities were incorporated.
|
|
|
|
 |
Chart 538
This is an example of the HI-CHART solution for stacked columns, see here for further information and links.
In this instance, an axis with double lines is used for the notation for "Months," the highlighting with ellipses is carried out automatically with Excel functions (here as well without programming). |
|
|
|
|
|
Chart 537
This is an example of the HI-CHART solution for stacked columns, see here for further information and links.
In this instance, active and passive data were displayed using two independent charts.
|
|
|
|
|
|
Chart 531a
This chart is a bar variation of Chart 530.
Caution: In Excel 2007 the afore-mentioned camera problems are found here.
|
|
|
|
|
|
Chart 530
Yet another variation on this theme, this time with 12 months. The arrow points are hidden when the differences are too small. |
|
|
|
|
|
Chart 521
In this instance, the same figures are used as in Chart 520 - however accumulated per year and calculating the monthly average.
This display is somewhat unusual, but also has distinct advantages over the usual stacked bar chart for annual cumulation.
|
|
|
|
|
|
Chart 520
Another variation for monthly planned/actual deviations. This instance is expanded to include projected figures (in another display). Everything "functions automatically" - even labeling.
Not a perfect solution, but a example that serves to demonstrate.
|
|
|
|
|
|
Chart 515
This example comes from a Hi chart in the Chart Chamber of Horrors.
The shortcomings of "one-dimensional" pie charts can be compensated well using a multiple array here.
In this example, a distinction is made between three different market categories (markets with a size of more than 5, 15, and 25 million EUR per year respectively).
|
|
|
|
|
|
Chart 511
Part of Chart 510; realized here, however, in a somewhat more elegant manner.
|
|
|
|
|
|
Chart 510
This examples comes from a Hi chart in the Chart Chamber of Horrors. The intent is to show that this display of differences makes it possible to gain a quick overview of the actual/planned comparison of four countries each with four product segments - for differences in both absolute values as well as in percent. You will find a similar display for developments over time in Charts 201 and 101
|
|
|
|
|
|
Chart 509
Instead of drawing several lines in a single chart, it is usually more transparent to select an exhibit with several line charts.
In this instance, the message is highlighted with four arrows that automatically assume one of four positions when specific threshold values are exceeded.
This solution was also created without macros or VBA.
|
|
|
|
|
|
Chart 501
The advantage of this trick is displaying a chart in the table - without the Excel chart function. This method is then advantageous if charts need to be integrated accurately to the last line. |
|
|
|
|
|
Chart 455
Here a particularly complex solution for a waterfall chart.
|
|
|
|
|
|
Chart 403
This solution corresponds to the one for Chart 401, but it is possible a) to charge the format of the bar labels* as well as b) to insert different icons.
*for example for the thousand point... |
|
|
|
|
|
Chart 402
Here a nice trick for automatic ranking in conjunction with the chart trick used in Chart 401 below.
The advantage of this table solution compared with other charts is that Excel rows of different heights can be considered automatically - this is virtually impossible for combining of Excel tables with Excel charts!
|
|
|
|
|
|
Chart 401
This solution has meanwhile become a "classic" among our seminar participants and has already brought about improvements in numerous management reports: A special character in Arial font is used to replace the bar of an Excel chart...
|
|
|
|
|
|
Chart 205
This solution shows few tricks, but helps illustrate the logic behind them.
We can do without the small VBA program here, it is only needed to modify font size. Waterfall Charts 103 and 455 are much more sophisticated.
|
|
|
|
|
|
Chart 204
This is a classic comparison of actual/projected values with planned values. This xls solution is NOT recommended, however, because the combination of tables and charts in Excel cannot be solved elegantly. This becomes obviously at the latest if the height of the individual rows is different. Use Chart 401 instead!
|
|
|
|
|
|
Chart 203
For charts with stacked bars, such as those shown here, cause substantially more problems when implemented with Excel.
This example shows one of our suggested solutions, but one which is not all that easy to implement. Bar and column charts do no react exactly in the same manner. |
|
|
|
|
|
Chart 202
This "three-dimensional" portfolio-like display brings on an entire series of problems which are solved here in part: Labels, scaling, and additional elements such as axes of coordinates or highlights.
A substantially more complex solution is provided by the HI-CHART prototype BUBBLES_1. |
|
|
|
|
|
Chart 201
This solution is intended to demonstrate that deviations between actual and planned figures are usually detected better in this form than with juxtaposed columns.
(See also Chart 101) |
|
|
|
|
|
Chart 131
This is a rather unusual, but also very creative display of a client project. This instance concerns bandwidths in wage development. This xls development was sponsored by one of our customers and is available for anyone interested to download free of charge. |
|
|
|
|
|
Chart 116
The arrow indicates the trend automatically. It was created using a scatter chart which is controlled using polar coordinates. This is an old trick to move the arrow - participants of our seminars know a better way to do this... |
|
|
|
|
|
Chart 115
This chart was realized using narrow columns, but was developed here as an area chart for demonstration purposes.
The width and height as well as the resulting area sizes were determined automatically.
|
|
|
|
|
|
Chart 114
According to the HI-CHART Rules, this chart should "actually" be a bar chart - but due to popular demand here now the column display. (Time is supposed to be represented as a column...). In this instance, five colors can be selected for the columns, otherwise there are no special tricks. (We would prefer the bar chart 113.) |
|
|
|
|
|
Chart 113
In this instance, the order of rank of product sales and product contribution margins is displayed automatically.
The colors can be selected through numbers.
|
|
|
|
|
|
Chart 111
This break-even analysis was developed tailored to a customer's needs and only must be adjusted if needed. Terms, benchmarks, etc. can be changed externally. |
|
|
|
|
|
Chart 110
This is a custom chart shown for demonstration purposes.
It is possible to modify for other specifications since all formulas are visible. |
|
|
|
|
|
Chart 109
In this layering of data series, individual values are either shown or hidden by entering an "x." |
|
|
|
|
|
Chart 106
This Excel chart is a tough one: The special problem here was the fact that the areas also need to be displayed accurately even when the intersection does not lie exactly within a certain section. This was carried out using an angle calculation. |
|
|
|
|
|
Chart 105
Red-green displays of this type can realized easily using two different data series. The other tricks, however, are "tricky"...
|
|
|
|
|
|
Chart 104
Red-green displays of this type can realized easily using two different data series. |
|
|
|
|
|
Chart 103
This is a further variation of the waterfall chart.
|
|
|
|
|
|
Chart 102
The intent here is to demonstrate how it is possible to use even sophisticated combinations without VBA and without macros. This was developed specially for a customer which is sponsored for other interested parties.
|
|
|
|
|
|
Chart 101
This shows a classic deviation analysis. The color selection can be changed by entering figures. The visibility of the numbers can be refined further depending on specific constellations.
See also Chart 201b
|
|
|
|
|
|
Chart 004
This is an extremely complex analysis, in which formats can be transferred from the table into the chart using the "Format" function. (A somewhat older solution that is no longer recommended in this form.)
|
|
|
|
|
|
Chart 003
This is an extremely complex analysis, in which formats can be transferred from the table into the chart using the "Format" function. (A somewhat older solution that is no longer recommended in this form.)
|
|
|
|
|
|
Chart 002
This is an extremely complex analysis, in which formats can be transferred from the table into the chart using the "Format" function. (A somewhat older solution that is no longer recommended in this form.) |
|
|
|
|
|
Chart 001
This is an extremely complex analysis, in which formats can be transferred from the table into the chart using the "Format" function. We no longer prefer this type of multiple superimposition - it makes the solution needlessly complex. |
|
|
|
