Minimize this window
Open Excel
Then click this application on the task bar to restore this page.

Look on your task bar. You should see "Microsoft Excel - Book 1" as one of the choices. Multitasking will require you to switch back and forth between files.

You could try resizing the windows so that you can view both applications at the same time. Or you can read this one then click "Microsoft Excel" on the task bar to complete your assignments.

Today we will be changing the value of the axis in a Microsoft Excel graph. Axis values will help us to create misleading graphs.

The following data needs to be entered into Microsoft Excel
Cell A1; type McDonalds
Cell A2; type Burger King
Cell A3; type Wendy's

Now lets enter the poll data into column B
Cell B1; type 8
Cell B2; type 5
Cell B3; type 2

Let's create a graph of this data. Which type of graph will be the best?

Click Cell A1 (McDonalds) and drag through cell B3 (2) so that all the data is highlighted.
Be careful not to highlight more than the data you want to graph.

From the menu bar you will choose Insert.
Chart may not be visible. If Chart is not visible click the little arrow at the bottom of the submenu.

Select Chart and we will begin graphing.

We agreed that a bar graph was the correct type of graph for this data.
In Excel, we must call it a column graph. Choose the "Clustered Column with 3D effect" as shown in the picture on the right.
Select "Next" to continue to Step 2 of the Chart Wizard.

The preview looks pretty good.
I don't like the colors and I hate the legend, but we will fix those in future steps.
Please choose "Next" to move on to Step 3 in the Chart Wizard.

The first thing that I want to do is get rid of the legend. Choose the Legend tab as indicated in the picture above.

Empty the checkbox beside "Show legend" so that the legend will disappear.
Then return to the "Titles" tab to continue working on our graph.

Type "Favorite Fast Food" into the Chart title text box.
We will not be adjusting the axis from the wizard so you may click "next" to move to the location step.

Click the radio button beside "As new sheet" and I chose to name the new sheet.
Type Favorite Fast Food into the text box.
Click "Finish" to create the graph.

Let's take a few moments to decorate our graphs.
Right click any gray area on the wall and choose "format walls"

Choose "Fill Effects"

Switch to the texture tab and choose a light gray type texture.
Select "OK" on the Fill Effects Menu.
Select "OK" on the Format Walls Menu.

Repeat the exact same process for the floor.
Right click the floor.
Choose "format floor"
Choose "Fill Effects"
Choose the texture tab
Choose the same texture you chose for the walls.
Select "OK" on the Fill Effects menu
Select "OK" on the Format Floor Menu.

Now decorate your data series the same way - I chose "Gradient"
Two Colors
Light Grey and Dark Grey.

Now it is time to mess around with the scale. We will start by making this data look better for Burger King.

To make the data look better for Burger King, we want to make the bars smaller and more even. To do this, we need to raise the scale.
Right Click on the vertical axis and choose format axis.

Make sure the "Scale" tab is selected.
To raise the scale we want to change the Maximum to 50
Then change the major unit to 10.
Select "OK" to apply the changes to the scale.

As you can see, Burger King doesn't look so bad in this graph.
Let's put our name on our work so that when it is printed our name will be on the paper.
Select "View" from the menu bar.
Choose "Header and Footer"
Choose "Custom Header"
In the "right section", type your name.
Choose "OK" to finish the wizard.

Now you can try messing around with the graph to favor McDonalds or even Wendy's. Which of the following is the only thing you are not allowed to do when you make a misleading graph?