How to Change Line Chart Color Based on Value

For example, to make a bar chart with the data in the table and change color in 5 different groups (1 - 15, 15 - 30, 30 - 50). Step 1: Sort data then arrange data similar to the table below, use formula =IF(AND(C$1 Line with Markers. Step [...]

2017-07-18T18:08:43+00:00 Categories: Basic, Chart, Tips|Tags: , , |0 Comments

How to Change Bar Chart Color Based on Value

For example, to make a bar chart with the data in the table and change color in 5 different groups (1 - 10, 10 - 20, 20 - 30, 30 - 40, 40 - 50). Step 1: Arrange data similar to the table below, use formula =IF(AND(C$1 Column [...]

2017-06-14T23:23:49+00:00 Categories: Basic, Chart, Tips|Tags: , , , |0 Comments

How to Make a Population Pyramid with Projection Lines

A population pyramid is a side by side bar chart and very useful to compare categories over time. Please follow the steps to make a population pyramid with the data below: Step 1: Prepare data and change one group of data to negative numbers (e.g., female in this [...]

2017-06-07T23:26:44+00:00 Categories: Basic, Chart|Tags: , |0 Comments

How to Modify the Axis Value to Change Chart's Appearance.

In many situations, you may need to modify the axis value to make your chart look better, if that is the situation, please refer to the following steps. For example, please make a column chart with the data below. Step 1: Select data, then in the Insert Tab, [...]

2017-05-31T22:23:08+00:00 Categories: Basic, Chart, Tips|Tags: , , |0 Comments

How to Show All Axis in a 3D Chart

To show all Axis in a 3D chart, please follow the steps below: For example, to make a column chart with the data below; Step 1: Select the data, click "Insert" from Ribbon, select "column chart", then select "3-D column"; Step 2: you will get the chart below; [...]

How to Create a Chart with Date and Time on X Axis

When you have a chart with date and time for the X Axis, please follow the steps below to change X axis format. For example, to make a column chart with the data below; Step 1: Select the data, click "Insert" from Ribbon, then select column chart; After [...]

2017-04-15T00:59:34+00:00 Categories: Axis, Basic, Chart|Tags: , , , , , , |0 Comments

How to Re-order X Axis in a Chart

to Reverse X Axis │to Sort Alphabetical Order 1. To reverse X Axis: Step 1: Right click on X Axis, then click "Format Axis" in the dialog box; Step 2: In the "Format Axis" window, check the box "Categories in reverse order". Step 3: You will find [...]

How to Wrap X Axis Labels in an Excel Chart

In some situations, your chart might come with long names which will shrink the chart and make your chart not great. To wrap the long names in the Axis, especially in the X Axis, please follow the steps below: Step 1: For example, with the data in the [...]

How to Change Font Color of Y Axis

1. All Font in the same color: To change the font color of Y Axis labels to the same, please select Axis, then change the font color in the Home Tab from the Ribbon; 2. Positive numbers in default and negative numbers in Red: To change Font Color to different [...]