Charts

A chart in excel is actually very easy to do. You simply have to select the data for which you want to compile a chart and the chart will be done based on the data.

For example if we have the following data:

You simply need a proper heading, and then just select a1:b5, like below. Go to insert, and select the type of chart you need.

The chart will given, based on you selection.

If you had more than one column of data, you can either select everything and then get one big unusable chart. For example, if we had the following data:

You chart on these data will look like follows, as you can see, it does not really make sense:

To get a better chart, only select the columns you need. For example, let’s select only the months, actual and budget.

This gives us a better chart.

Remember not to select the totals as well.

<-----Back to index

Next topic----->