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 [...]

How to Group Axis Labels in Chart

To group axis making a better chart, simply to add another category column, please follow the steps below: Step 1: For example, to make a chart with the data in the table blow; Click "insert" in the Ribbon, then select "column chart"; Step 2: To have another bigger [...]

2017-04-10T00:11:56+00:00 Categories: Axis, Basic, Chart|Tags: , , , , |0 Comments

How to Hide Zero in Axis in Chart

Sometimes you may want to hide 0 in the Y Axis. To hide 0 in the Y Axis, please follow the steps below: Step 1: Right click Y Axis, then click "Format Axis" in the dialog box; Step 2: In the "Format Axis" window, under "Number" section, change [...]

2017-04-10T16:23:27+00:00 Categories: Axis, Basic, Chart|Tags: , , , , |0 Comments

How to Rotate X Axis Labels in Chart

To rotate X Axis Labels in Chart, please follow the steps below: Step 1: Right click X Axis, then click "Format Axis" in the dialog box; Step 2: In the "Format Axis" window, select "Rotate all text 270" in the Text direction section; Step 3: The following is [...]

2017-04-08T23:13:02+00:00 Categories: Axis, Basic, Chart|Tags: , , , , |0 Comments

How to Move X Axis Labels from Top to Bottom

To move X Axis labels from top to bottom, please follow the steps below: Step 1: Right click X Axis, then click "Format Axis" in the dialog box; Step 2: In the "Format Axis" window, select "Low" in the Label Position section; Step 3: The following is the [...]

2017-04-08T15:12:19+00:00 Categories: Axis, Basic, Chart|Tags: , , , , |0 Comments

How to Move X Axis Labels from Bottom to Top

To move X Axis labels from bottom to top, please follow the steps below: Step 1: Right click X Axis, then click "Format Axis" in the dialog box; Step 2: In the "Format Axis" window, select "High" in the Label Position section; Step 3: The following is the [...]

2017-04-08T15:03:53+00:00 Categories: Axis, Basic, Chart|Tags: , , , , |0 Comments