Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP HOW TO W3.CSS C C++ C# BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS R TYPESCRIPT ANGULAR GIT POSTGRESQL MONGODB ASP AI GO KOTLIN SASS VUE DSA GEN AI SCIPY AWS CYBERSECURITY DATA SCIENCE
     ❯   

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

Table Pivot

Table Pivot Intro

Excel Case

Case: Poke Mart Case: Poke Mart, Styling

Excel Functions

AND AVERAGE AVERAGEIF AVERAGEIFS CONCAT COUNT COUNTA COUNTBLANK COUNTIF COUNTIFS IF IFS LEFT LOWER MAX MEDIAN MIN MODE NPV OR RAND RIGHT STDEV.P STDEV.S SUM SUMIF SUMIFS TRIM VLOOKUP XOR

Excel How To

Convert Time to Seconds Difference Between Times NPV (Net Present Value) Remove Duplicates

Guided Projects

Introduction to Excel Learn Data Calculations Learn Data Visualization Learn to Create a Budget Learn to Create a Timeline Learn to Style in Excel

Excel Examples

Excel Exercises Excel Certificate

Excel References

Excel Keyboard Shortcuts


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