How to create an area chart
The area chart is similar to the line chart except that the area below the line is filled, use this chart to plot data over time or categories (non-numeric).
The time interval must be evenly distributed, use the scatter chart if not. The image above demonstrates time values (years) evenly distributed from 2010 to 2016 (x-axis).
How to build
- Select the data you want to graph.
- Go to tab "Insert".
- Click the "Insert line or area chart" button.
- Click the "Area" button.
How to add a second series
- Right click on chart.
- Click on "Select Data...".
- Click "Add" button.
- Click "Series values:" button.
- Select the data source.
- Press Enter
- Click OK button.
- Click OK button.
Question: How do I create a chart that dynamically adds the values, as i type them on the worksheet? Answer: […]
How to use mouse hover on a worksheet [VBA]
I recently discovered an interesting technique about using a user defined function in a HYPERLINK function. Jordan at the Option […]
Change chart data range using a Drop Down List [VBA]
In this article I will demonstrate how to quickly change chart data range utilizing a combobox (drop-down list). The above […]
Color chart columns based on cell color
This article demonstrates macros that automatically changes the chart bar colors based on the corresponding cell, the first example is […]
How to create an interactive Excel chart [VBA]
This article describes how to create an interactive chart, the user may click on a button or multiple buttons and […]
Leave a Reply
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.