martes, 11 de marzo de 2014

How to use graphs and charts in Excel 2010

Using graphs is a very important step in Excel, is very useful and also easy:

There are lots of types of charts:

Column
Slide 1
Line:
Slide 1

Pie:
Slide 1

Bar:
Slide 1










Area:
Slide 1

Surface:
Slide 1

and others

So if you want to add a chart, you need to follow this steps:

1. Select the cells that you want to chart, including the column titles and the row labels. These cells will be the source data for the chart.
Selecting cells

2.Click the Insert tab and choose the type of graph you want to use:
Selecting the Column category

3. Select the  chart type:
Selecting a chart type


4. Finally it will end like that:
The new chart


If oyou dont like the design or if you want to change the type of chart, you can do this  in the Chart Tools Layout:

The Design, Layout and Format tabs

The Change Chart Type command

The Change Chart Type command


If you need more details about it, see this video: LINK HERE 

No hay comentarios:

Publicar un comentario