Office 2010 - Excel

Lesson 47: “Charts” (1)

47/87 Lessons 

Creating “Charts”

To add a “Chart”, we first select the data range for which we want to create our “Chart”.

Then select the “Insert” tab in the “Ribbon”.

You will see different types of “Charts”.

Depending on the data you want to incorporate into your “Chart”, certain types are more suitable than others. Clicking on an icon, shows a drop-down menu. To insert a “Chart”, click on one of the “Charts” in the drop-down menu.

This places the selected “Chart” in the middle of the “Worksheet”.

 

“Chart” format

When we have made a “Chart” and it is selected in the “Worksheet”, there will appear three additional tabs in the “Ribbon”.

These tabs provide us with the commands we need for formatting the layout of our “Chart”.

 

When a “Chart” is created, it will be displayed with its defaults.

The Chart legend will be shown on the right, the values on the y-axis, the categories on the x-axis and the category titles at the bottom of the x-axis as seen in our product example below.

But “Charts” can also have “Titles”, and “Tables” can be included, and the “Legend” can be moved upwards, right, or bottom.

Rather than doing the formatting manually, we can make use of the ” Chart Layout”.

Clicking the arrow opens another pop-up menu with different formats.

 

For example, the first option allows us to add a title for our “Chart”.

Another option will move the legend below the x-axis.

TWe can also an intermediate data table to our “Chart”.

All these preloaded formats can save us some time, but you can also add or remove items yourself.

Try some of these or continue with the “Undo” toolbar and click on “Quick access” to return to previous designs.

 

Awesome!
You've completed Lesson 47
START NEXT LESSON