Frequently Asked Questions

How to create charts in Excel?
Last Updated 6 years ago

To create a chart, select the cells that contain the data and text that you want to appear in the chart.

Select the cell range A1:E5.


image

Select the Insert tab, then in the Charts group, click on the Chart button. The chart sub-types will appear which will provide you more chart options to select from. To view all chart types, click on the dialog box on the Charts group. The Insert Chart window will appear with all chart types.

Select the All Charts tab.

image

Click on the first Column button in the window.

Click on the OK button.

Your chart selection will appear on the spreadsheet


image

When the chart appears on the spreadsheet it will have a selection boarder around it. Charts are similar to graphical images which can be moved and resized.

Move the chart.With the chart object selected, point inside of the object border. Click and drag to move the chart to a new location (the mouse pointer changes to a four-way arrow).

Resize the chart. With the chart object selected, position the mouse pointer on any handle and drag in the direction indicated by the double arrow pointer.



Please Wait!

Please wait... it will take a second!