Introduction
There are many addin's on the market to get the best out of Excel and its charting capabilities. But sometimes its fun to construct something yourself and prove a point in the process. Our little exercise is meant to visualize why some chart types look better in dealing with price series than others. For example we can use point and figure charts. One of the advantages of these types of charts is their tendency to smooth out noise in price behaviour. And this is what we are going to show in a simple exercise and create a small building block of our own visual trend analyser at the same time.

Continue Reading: Creative with Excel Charts; Same data, More Info »