Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to use Excel MMULT Function
  • How to get address of first cell in range in Excel
  • How to get relative row numbers in a range in Excel
  • How to reference named range different sheet in Excel
  • Merge tables with VLOOKUP in Excel

Data Analysis Examples

  • How to create Gauge Chart in Excel
  • Add Outline to Data in Excel
  • How to calculate average last N values in a table in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How To Compare Two Lists in Excel

Data Validation Examples

  • Excel Data validation must contain specific text
  • Excel Data validation must begin with
  • Excel Data validation allow weekday only
  • Excel Data validation require unique number
  • Excel Data validation must not contain

How to Create Area Chart in Excel

by

An area chart is a line chart with the areas below the lines filled with colors. Use a stacked area chart to display the contribution of each value to a total over time.

To create an area chart, execute the following steps.

1. Select the range A1:D7.

2. On the Insert tab, in the Charts group, click the Line symbol.

3. Click Area.

Result. In this example, some areas overlap.

Below you can find the corresponding line chart to clearly see this.

4. Change the chart’s subtype to Stacked Area (the one next to Area).

Result:

Note: only if you have numeric labels, empty cell A1 before you create the area chart. By doing this, Excel does not recognize the numbers in column A as a data series and automatically places these numbers on the horizontal (category) axis. After creating the chart, you can enter the text Year into cell A1 if you like.

Post navigation

Previous Post:

Paste Special Operations in Excel

Next Post:

Freeze and Unfreeze Panes in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • ASC function: Description, Usage, Syntax, Examples and Explanation
  • BAHTTEXT function: Description, Usage, Syntax, Examples and Explanation
  • How to extract domain from email address in Excel
  • How to count total words in a range in Excel
  • Extract middle name from full name — Manipulating NAMES in Excel
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • HOUR function: Description, Usage, Syntax, Examples and Explanation
  • Calculate retirement date in Excel
  • Add years to date in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
  • SYD function: Description, Usage, Syntax, Examples and Explanation
  • DDB function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles