📜 ⬆️ ⬇️

I adore beautiful charts

One of my colleagues once said: “And what is necessary, to draw all sorts of beautiful graphics. Dead time! ”I suppose that is not necessary. However, I can not stand when people can not take care of the final presentation of their work. Like the fact that he washed, shaved, ate, drank coffee, went outside, and then he was told that he had socks on his ears, three prints from his boots and a poured bottle of ketchup on his shirt. Not prudent, in general.

The first rule, which Zelazny writes about (best-selling author on diagrams):
Use your main idea as a chart title. By following this advice, you will help the reader correctly understand your thought and gain confidence that he will focus his attention on that aspect of the data presented that is particularly important .

My opinion is that without this the schedule and its idea will not reach its goal. No faceless "sales plan", "sources of investment", and especially "market share" :)
Example of the name of the graph

To resort to visual means of displaying data, it should be when there are more than three numbers, for example, and it is already difficult for a person to interpret them in this form. Naturally, the information presented graphically perceived easier and more accessible. However, it’s a bad idea to think that a diagram mistakenly presented or made without a basic idea can help. So, another mess in my head.

Naturally, the diagram can not live without text. Therefore, in addition to the main idea, made in the title, it would be a great decision to use notes, comments, direct emphasis on a particular value. The heading, with good comments, can in principle be neglected.
')
Seasonality forecasting
And of course the color.

Highlighting in the diagram

There are many tools for data visualization. I will not miss if I say that at least 90% of you use Excel. The tool is far from ideal, but in the latest release, developers almost managed to understand the needs of analysts. Although some rightly disagree with this :)

The possibilities of different programs in the construction, chart patterns, colors and fonts actually affect the final picture. Here are the same diagrams made in different programs (default formatting was used).

Excel 03



Excel 07


Numbers
Comparison of visualization. Numbers
In general, every manager or analyst needs to issue a D.Zhelyazny book or look at graphics from Juiceanalitics - I wrote about them. Believe me, this knowledge for 570 rubles is better than any idiotic courses like “Become insanely cool Excel user”.

(full ice blog)

Source: https://habr.com/ru/post/17954/


All Articles