Microsoft Excel is a spreadsheet program used to store and retrieve numerical data in a grid format of columns and rows. The software is ideal for entering, calculated and analyzing company data such as sales, taxes or commissions.
Excel offers far more tools for calculating trends, deciphering profits, creating numerical formats and visual data.
Excel offers far more tools for calculating trends, deciphering profits, creating numerical formats and visual data. (Youtube)
These are simple guidelines on how to create charts in Microsoft Excel.
Charts are used to display series of numeric data in a graphical format to make it easier to understand large quantities of data and the relationship between different series of data.
To create a chart in Excel, you start by entering the numeric data for the chart on a worksheet. Then you can plot that data into a chart by selecting the chart type that you want to use on the Insert tab, in the Charts group.
- Click the Insert tab
- Click the chart type from the Charts section of the ribbon. The sub-type menu delays.
- Click the desired sub-type. The chart appears on the worksheet.
- If you want to create a second chart, click somewhere in the worksheet to “deselect” the current chart first, or the new chart will replace the current chart.
In older versions of Excel such as Excel 2003, 2000, and 98 do the following:
- Click Insert Chart. The Chart Wizard appears.
- Click the desired chart type in the left column and click one of the chart sub-types in the right column. Click Next.
- Excel assumes you wish to keep the series data in rows. You may click “Columns” to see how the chart changes. When finished, click Next
- Type a chart title. If you wish to add a title for the axes, do so. Then click Next
- Excel assumes you want the chart placed on the worksheet. If you would like the chart placed in a new sheet, click the radio button, type a sheet name and click Finish.