The Easiest Way to Create a Chart

     Have someone else do it...

     Just kidding.

The Easiest way to Create a Chart

Okay, are you ready for the Easiest way of Creating a Chart?

Well, I hope that you are because I am going to give it to you even if you do not want it.

The First thing that you need to do is to select the Data Range for your Chart. I would like you to select the Range of Cells from A5 to G13.

No w that that is done.

Now, you have two hands, Right?

Ten fingers or perhaps you may say no I have eight fingers and two thumbs.

Hold your hands up, either hand I want you to choose one finger, not the third finger over from either direction…

Some people get that joke right away, makes me wonder do they use that finger a lot…

There is the Functions Button Row on your Keyboard, the F1, F2, F3, F4, all the way to F12. It is usually the upper most row of Buttons on the Keyboard. They are actually good for something other than catching dust. Well I want you to use the finger that you chose and click the F11 Button.

Ka-pow…

Two things should have happened simultaneously Excel should have created a Tab Called Chart1 and it also created the Chart.

Did I lie, was that not the easiest way that you created a Chart?

Okay, I would like for you to go back to the Charts Tab and this time Select Cells A5 to G5 and Cells A15 to G15. It should look something like the below picture. Then use the F11 Key again.

You should get a Second Chart on a Chart2 Tab. Now you have the option of showing the Boss both charts in an uncluttered Spreadsheet. Or you could have something that looks like this. Which looks best to you, the three Tabs or the One Tab with all the information on it?

What choice is the easiest to read, especially for the audience?