How to Add or Remove Axis Title

Add Axis Title │Remove Axis Title Please follow the steps below to add or remove a X Axis Title: Step 1: To add an Axis title, click anywhere on the chart, "Design" Tab will appear in the Ribbon; Step 2: In the "Design" Tab, click "Add Chart [...]

2017-03-23T18:25:37+00:00 Categories: Basic, Chart|Tags: , , , |0 Comments

How to Make a Thermometer Chart

A thermometer chart, also a progress chart, displays the progress how much you have achieved to a goal. For example, to create a weekly progress chart with the goal of $5,000 in 12 weeks for a non-profit organization funding raising. Step 1: Suppose we have the raised funding [...]

How to Change a Chart from 2-D to 3-D

Suppose we have a regular column chart below and need to change it to a 3-D chart (check here to make a column chart). Step 1: Right click anywhere on the chart, select "Change Series Chart Type"; Step 2: In "Change Chart Type" window, click "Column" in the [...]

2017-03-19T23:20:07+00:00 Categories: Basic, Chart|Tags: , , |0 Comments

How to Make a Side by Side Comparison Bar Chart

A side by side bar chart is useful to compare two categories over time. The chart displays the trend of each category as well as the differences between the two categories at each point. Suppose we have the number of boys and girls participated in one activity in the last [...]

2017-03-19T00:01:53+00:00 Categories: Basic, Chart|Tags: , |0 Comments

How to Make a Stock Chart

A stock chart is specialized to illustrate the fluctuation of stock prices and normally involves a series of days. Not like other charts, a stock chart requires your data to be arranged in one of the following orders: High-Low-Close; Open-High-Low-Close; Volumn-High-Low-Close; Volumn-Open-High-Low-Close; Step 1: Suppose we have the [...]

2017-03-17T00:32:54+00:00 Categories: Basic, Chart|Tags: , |0 Comments

How to Make a Combo Chart with Two Bars and One Line in Excel 2010

If you have Excel 2010 and you are making a combo chart with two Bars and one line, please follow the steps below. Excel 2016 has made this much easier, if you are working with Excel 2016, please refer here for details. Step 1: Suppose we are making [...]

How to Make a Combo Chart with Two Bars and One Line

Suppose we have the number of persons and percentage who met the criteria in each region, and the total persons who participated. We need to make a combo chart to include all these 3 fields. Step 1: Highlight the data in the data range A1:D6; Step 2: In [...]

2017-03-16T20:38:37+00:00 Categories: Basic, Chart|Tags: , , , |0 Comments