Charts are an integral part of a variety of presentations, slideshows, business programs, and financial reports. With the help of a diagram, you can visually display how one or another aspect of the company's work has changed over the years, or show the percentage of various parameters. A beautiful and understandable diagram will be more understandable to the reader and viewer than an obscure drawing, therefore it is very important to learn how to draw beautiful, clear and obvious diagrams that will help you in your work.
Instructions
Step 1
In Microsoft Excel, you can, by specifying your options, create an automatic chart from program templates, but these charts are neither clear nor aesthetically pleasing. Based on a ready-made chart in Excel, you can create your own chart, which is more visual, concise and stylish, using the same parameters.
Step 2
In the previous diagrams, get rid of all the unnecessary. Your diagram should resemble a lightweight and understandable graph, freed from unnecessary details, transparent and aesthetic. For the graph to be clear, do not use more than two colors in it. Red, black and shades of these colors are the best options for any chart. This will make it easy to read the information on each scale. Be sure to reflect a noticeable increase in parameters in the graph.
Step 3
If you have two charts, the indicators of which can be combined into a common chart, use this opportunity - make one common convenient chart. Color each parameter in its own color.
Step 4
It is not necessary to show the ratio of different indicators in one column of the diagram - such information will not be read by the viewer. It would be much better to divide each column into two - red and black. Each column will show the value of one or another indicator, and in accordance with it, the height of the column will be shown. However, reading the information can still be difficult as the number of columns increases and it is difficult for the reader to relate them to the overall values on the lower scale.
Step 5
The same chart will look much more accurate, in which the main scale (for example, distributing the results by year) will be located vertically, and all the columns will be directed to the side. Since the long numbers will also run horizontally, the chart will not give the impression of too much data.
Step 6
Place each pair of columns on one scale parameter in a field of the third color (for example, gray) for greater clarity, and display the gray stripe sideways to a length corresponding to the total indicator of the two scale-columns. Write the general indicator in the numerical version to the right of the strip, using the same gray color. In this form, the diagram will already be easy to read.
Step 7
You can also try to make a regular vertical chart clear and neat by aligning the scales in a different way than at the beginning. Columns for some indicators are above the main scale for total and total numbers, while columns for others are below the scale. This will make the data separate from each other and understandable, and at the same time, combined into a big picture.
