SUCCESS Diagrams are the fourth generation of graphical data display in the excel. Although simplicity and minimalism in the presentation of data is emphasized, so the “successful” display of data in the excel that has too many parameters for the diagram elements presents a real challenge.
SUCCESS Diagrams
In search of a good example of data presentation I could never escape the MCB and the controller association. On the How to find a site you can see an example of a presentation of data in a whole new way.
At the first moment, I thought it was a trivial business and it was easy to solve the graphical display of data from the table, but that’s not the case.
In the next three sequences, we will solve each diagram on a step-by-step basis, and gradually submerge into the world of the diagram in the excel.
The first diagram – the absolute values of the reference year
Step 1: select the X and I columns where the data that we want to display is. In this case, it is the Buyer column and next column 2013.
Step 2: Select the Insert toolbar and the Recommended Charts button (as in the picture).
Step 3: Before removing all unnecessary items, select the X axis and type the Categories in reverse order option.
Step 4: In addition to determining the color, turn off the markings on the X axis and turn off X axis display.
Step 5: Just set the diagram and the desired size.
____________________________________________________________
SUCCESS® is a concept developed by the Swiss prof. Hichert for the purpose of creating a Management Report (Administrative Report). You can read more about this here.