Click 'OK' to go back to the Select Data Source window. Click and hold the mouse button on cell 'A2,' then drag the mouse down to the bottom of your list of years. A small window will appear.Ĭlick 'Edit' under the 'Horizontal Axis Labels' heading on the right side of the window. Click the 'Select Data' button, located on the ribbon. Select the chart, then click the 'Design' tab at the top of the screen. The chart will appear on your spreadsheet. Choose your desired type of chart from the options that appear when you click the button. Click on the 'Column,' 'Line' or 'Bar' buttons, as these are the only three types of charts that will work well with this kind of data.

Click the 'Insert' tab at the top of the Excel window. Do the same thing down each column until you have entered all of your data.Ĭlick on any cell where you have entered data. Click on cell 'B2' and enter the data that corresponds to that first year.

Example of relational databases are MySQL Database, Oracle, MS SQL Server, Sybase, etc.Click on cell 'A2' and enter the first year that you have data for.

SQL can do lots of other operations, including optimizing and maintenance of databases.

SQL can be used to insert, search, update, and delete database records.

SQL (Structured Query language) is the standard language for dealing with Relational Databases.

They support electronic storage and manipulation of data.

A database is a systematic collection of data.

Scatter chart: It is to observe how the values of two series compares over time or other category.

Area Charts are used primarily to show trends over time or other category.

Area chart: It is like Line Charts except that the area of the plot line is solid.

The horizontal axis of a Bar Chart contains the numeric values.

Bar chart: It is like a Column Chart lying on its side.

The vertical axis (Y-axis) always displays numeric values and the horizontal axis (X-axis) displays time or other category.

Line chart: It is especially effective in displaying trends.Column chart: It effectively compares a single set of data points, but it shines when comparing multiple series.A data series is a row or column of numbers used for charting. Pie chart: It displays one series of data.Excel Chart Types: Pie, Column, Line, Bar, Area, and Scatter.A chart is a tool which can be used in Excel to communicate data graphically.Graphics used for creating chats to represent numeric data.

How to plot a graph in excel 2010