No one will dispute that a histogram is a good tool for displaying data visually. Just by looking at such a diagram, you can quickly assess the situation without resorting to the analysis of numerical values in the table. That is why the world-famous spreadsheet editor Excel has adopted this tool.
The article will talk about how to build a histogram in Excel. Four construction methods will be analyzed, each of which is sufficiently different from each other. That is why it is worth reading the article to the end in order to choose a method for yourself. At the end of the article, we will also give an example of building a histogram in Word.
Histogram
Excel has the ability to build a histogram in three ways:
- using a special tool;
- Using conditional formatting
- .
, Excel. , - - .
:
, . , "". "", "".
, . , .
Excel , . , , " ".
:
, . . , , - : . .
"", "" "" . , .
, . , , , , " ".
:
, . .
. , "". "". "" "" " Excel". "".
, " " "".
, . "" - .
" ", "". , "" "".
, . " " , . " ". , . - , . , "".
.
:
, , . .
, , , . , "" " ". "" . : . , .
, .
""
, "". "", .
, , , . "" "" " " - .
"", . , , , - "".
Your histogram appears on the Word sheet. Notice that under it there will be a small "Excel" table for data entry. Set the necessary variables and enjoy the result.
Now you know how to make a bar chart in Word. It should be noted that this is no more complicated than in Excel.