Producing charts from a worksheet

A chart is used to give a visual representation of data. A chart makes the data more attractive and interesting so that it can be read, understood and analysed quickly. A wide variety of charts can be created from worksheets. Different chart types display information more effectively than others depending on the data. Excel has fourteen different types of chart available and in this section we will look at two: pie charts and bar graphs.