Excel Charts

Excel is the most user friendly chart creator.

In the example below you select cells A1 to C6 and you click on the chart icon of the toolbar

The "Chart Wizard" dialog window appears. You select "Column" in "Chart Type", you select a "Chart sub-type" and you click on "Finish". You resize the chart and set it where you want it.

Now right click in the white space around the chart. A menu appears. Select "Format chart area/Properties" and check the "Don't move or size with cells".

Now hide row 2 and notice that the chart shows only the data for the rows that are visible (see below). This tip can be useful for making your point in an on screen presentation.

To delete the chart just select it and click on "Delete".

If you choose to create a "Line" chart and some data are missing yet you don't want the lines to be broken. Go to the menu bar "Tools/Option/Charts and select "Interpolated.

Learn more on Excel
See the list of small downloads

There are  five sections in this website

Section 1: About Databases: 4 lessons
In this section we review the basic notions on databases and evaluate Excel as a database. You will then see how Excel can be used downstream from most centralized databases and data management programs. Finally we will discuss the "upgrade" from Excel to Access..
Section 2: Excel and External Data: 7 Lessons
There are many ways to get data into your Excel Workbooks and there are many ways to easily extract data from all the databases in your organization and the Internet. This section is centered on querying data
Section 3: Analyzing Data with Excel: 8 lessons
Once you have the data in the right formats within your Excel workbook it is time to use the powerful analytical tools of Excel including the database functionalities (sort, filter, subtotals), the integrated calculator, the comparative analysis tools and the mysterious and not so complicated pivot tables. 
Section 4: Reporting with Excel: 7 lessons
The report is a communication tool and you can not accept to compromise on its presentation. Excel is the best reporting tool allowing you to easily develop popular dashboards and to share these reports with multiple colleagues.
Section 5: Other Functionalities in Excel: 3 lessons
In this fifth section you will review the useful CTRL and ALT keystrokes, the conditional formatting, the drop-down lists and other interesting functionalities.