Excel Lesson Plan- A Simple Bar Chart
This Excel Lesson Plan Teaches Users to Enter and Format Data and Create a Simple Bar Chart
The instructions are for Microsoft Excel 2007 - 2010 version, but the data and chart can be recreated using any of the various Excel versions or even non Microsoft variants. I have used this successfully with 2nd and 3rd graders, but your mileage may vary.
2 Minute Excel Video Tutorial - How to Make a Bar Chart
This lesson builds on the Excel First Chart lesson by adding the following requirements:
- Merge and Center the title. "Nicole's Fruit Chart"
- Apply formatting to the title such as font size, color, and style.
- Enhance the chart by using "Chart Layouts" menu and labeling the title and horizontal and vertical axis.
Use this mini excel tutorial to guide your students in entering the data and creating the chart.
- Enter your chart title in C1.
- Click in cell C1 and drag mouse to H1. In the Home tab, alignment group, find and apply
"Merge and Center" to the title.
- With the title still selected, on the Home tab, Font group, apply a new font color, font size
and font style.
- Enter the fruit labels in colum A starting with cell A3. Enter the fruit quantities in column B starting
in cell B3.
- Click in cell A3 and drag mouse down to select all the foods down to cell A6. Continue to drag to select all the numerical values on column B.
- Create a bar chart. Go to Insert tab > Charts group > Bar > 2D bar.
- Format the chart. Click to select the chart. Go to Design tab > Chart layouts group > choose a chart layout that will produce a chart title and horizontal and vertical axis labels.
- Fill in the appropriate text for the Chart Title and the axis. "Nicole's Fruit Chart, Fruits and Quantity".
- In the Design tab > Chart Styles group, choose a style for the bars.
- Go to Print > Print preview, make adjustments to chart position as necessary. Print.
Excel Simple Bar Chart Example: