Tutorials References Exercises Videos NEW Menu
Paid Courses Website NEW

Excel Tutorial

Excel HOME Excel Introduction Excel Get Started Excel Overview Excel Syntax Excel Ranges Excel Fill Excel Move Cells Excel Add Cells Excel Delete Cells Excel Undo Redo Excel Formulas Excel Relative Reference Excel Absolute Reference Excel Arithmetic Operators Excel Parentheses Excel Functions

Excel Formatting

Excel Formatting Excel Format Painter Excel Format Colors Excel Format Fonts Excel Format Borders Excel Format Numbers Excel Format Grids Excel Format Settings

Excel Data Analysis

Excel Sort Excel Filter Excel Tables Excel Conditional Format Excel Highlight Cell Rules Excel Top Bottom Rules Excel Data Bars Excel Color Scales Excel Icon Sets Excel Manage Rules (CF) Excel Charts Excel Charts Customization

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions

AND AVERAGE AVERAGEIF AVERAGEIFS COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS MAX MEDIAN MIN MODE OR STDEV.P STDEV.S SUM SUMIF SUMIFS VLOOKUP XOR

Excel Exercises

Excel Exercises


Excel Chart Customization


Chart Customization

Charts in Excel can be customized.

Customization can be helpful to make the data easier to understand. For example to highlight key points, give additional information and make it look better.

Excel has many options for how to customize a chart. You will learn more about the different options in this chapter.

This doughnut chart shows the ratio of different Pokemon types in generations 1 and 2.

The "Water" type, shown in gray has the most Pokemons in both generations. Then there are types "Bug", shown in yellow, "Grass", shown in blue and "Fire", shown in orange.

Note: Different charts can be customized in different ways.


Moving Charts

Excel charts can be moved around the spreadsheet.

How to move a chart, step by step:

  1. Select the chart by clicking on it.

Note: Selecting a chart highlights its borders.

  1. Drag the chart and place it where you want


Resizing Charts

Excel charts can be resized.

Resizing will scale all the elements in the chart except the text.

How to resize a chart, step by step:

  1. Select the chart by clicking on it.

  1. Click and drag one of the 8 points shown on the chart border and drag them

Note: The arrows in the image above are pointing to where you can drag to resize the chart.

The chart is now resized. This can be done as many times as needed to get the right size.


Changing The Chart Title

The default chart title in Excel is "Chart Title". This is not informative. The title should describe the chart.

Changing the title, step by step:

  1. Double click on the chart

This opens up a menu on the right side of your screen.

  1. Find "Chart Title" text in the newly opened menu and change it

Now, the title has changed to "Pokemon Stats".

Note: You can remove the chart title by clicking on it and pressing the Deletekey on your keyboard.


Customization Options

Charts can be customized in different ways, here are some elements you can change:

  • Legends
  • Axis
  • Data labels
  • Grid lines
  • Styling and formatting