Pay attention to the chart, which is built according to the same table. You can, of course, use the «Sorting» tool, but then the general idea of the seasonality of the firm's activity is lost. For example, pay attention to the picture:Īccording to the table, you do not immediately to notice in what month the company's revenues were the highest, and in what the smallest ones. How not to create a table, its data will be less readable than the graphical representation in diagrams and charts. To do this, make a double-click on the title with the left mouse button and enter the text as shown in the picture:Īfter you sign a new title, click on any cell to deactivate the chart settings and go to normal mode. From the group of different chart types, select the «Doughnut». Select «INSERT» – «Insert Pie or Doughnut».Select the A1:B4 range in the source table.Now we are constructing the diagram according to the data of the Excel table, which must be signed with the title: How to build a chart on the table in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |