The ideal solution for visualizing data in a table is, of course, a histogram. The type of such a diagram is capable of conveying to the ordinary user the basic essence of all the values without even having familiarized themselves with them.
The article will parse the histogram in Excel. How to make it, you will learn after reading the article. In addition, all the nuances that arise during the construction process will be considered. You will also be introduced to four different options that show how the histogram is built in Excel.
Options for building a histogram in Excel
The most popular table editor offers the following options for building a histogram:
- simple histogram;
- stacked histogram;
- using analysis package;
- with conditional cell formatting.
, . , Excel.
1:
Excel . , .
, . "" "". . "" . , , .
, , , .
Excel. , . , , , " ".
2:
, , Excel. .
, , . , , .
. , , , . "", "" "" . , .
Excel.
, " ". , , , .
3:
, . , , .
. "" "". "".
"". " Excel" "". . " " "".
, "". " ", "".
"" "" - , . " " . , . " " , . "".
4:
, "" " ". "" .
- . , , .
, Excel. - , .