Archive for Graphs

Displaying Graphs in a Cell

With the arrival of Excel 2010 there’s a new tool that complement the graphics in Excel. These are the sparklines or graphics from a single cell. With them you can now create tiny integrated graphics within each cell. These will be used to easily detect patterns of data tables. This is a very simple and quick to highlight important trends that data (such as seasonal increases and decreases).

In this little mini tutorial for Excel will see how they are generated:

To make use of sparklines we will only select the cells where we place these graphics in miniature (usually a column next to the data table). Then, click on the Insert tab–sparklines, choosing row, column or gain or loss. In particular, the choice seems more visual in the online format. The format with gain or loss is very suitable for interpreting balance sheets.

Mark the range of cells that we use as the basis of the graphs and these will be generated instantly.

It is very fast, simple and intuitive interpretation of the data table, identify trends and monitor developments. What were initially quite difficult to read a set of numbers has now become easily understandable.

In previous versions you would have generated a graph that includes all the series (if you use the same scale) or a chart for each of them.

The value offered by this new feature of Excel 2010 is evident.