Diagrams Of A Cell In Excel

Posted by on

Until the version 2007 of Excel, to see a visual representation of the data the well-known graphs were used, but with the arrival of Excel 2010 a new tool is born that come to complement the graphs in Excel. One is the minigraphs or graphs of a single cell. With them now it is possible to create tiny graphs integrated in within each cell. These will serve to easily detect the models of the data of the tables. One is a very simple and fast form with which to emphasize the important tendencies of the data (as they can be the seasonal increases and diminutions). In this small mini tutorial of Excel we will see how they are generated: In order to make use of the minigraphs we will only have to select the cells where we want to locate these graphs in miniature (generally a column next to the table of data). Later, we make click in the eyelash Insert > minigraphs, choosing line, column or gain or loss. Particularly, the most visual option seems to me the format line.

The format gain or I very see it to loss indicated at the time of interpreting balance, in which it is frequents the appearance of red numbers. Later, we will mark the rank of cells that we are going to use as it bases of the graphs and these are generated right away. As it is possible to be observed in the figure. He is very fast, simple and intuitive to process the data of the table, to identify tendencies and to observe evolutions. What at first they were a set rather little legible of numbers now has turned into something easily understandable. In previous versions it would be necessary to have generated a graph that included all the series (if they used the same scale) or a graph for each of them. The value that contributes this new functionality of Excel 2010 is evident. Original author and source of the article.