Excel tutorials

How to Display a Specific Sign or Character or Text in a Excel Chart

In this tutorial I will show how to create a chart when the data is specific and we want to show only one column. These specific data, signs or characters can be text, 'star sign' or 'star with a number'. In the picture below you can see an example of the completed chart. Furthermore, in the tutorial you see how to create a Chart with specific characters in the X axis in Excel.

 

Specific signs, characters or text on the X axis Excel chart-graph

In Excel table we have two columns with data. In the 'Column 1' are the specific data to be mapped on the horizontal X-axis graph for each value on the vertical Y-axis from 'Column 2'.

Step 1.

Creating a Chart in Excel

Select the data table. On the 'Insert tab' click on the 'Insert Column Chart' icon/button. Select the '2-D Column' command and first template 'Clustered Column'.

Create 2D Column Excel Chart

Now we have created an Excel Chart like this one in the picture below.

Creating a 2D chart in Excel

Step 2.

How to change the range of data in Excel Chart

Let's make some changes to the chart to get the desired result. Click double click on a frame chart. On the Ribbon appeared 'Chart Tools Format' toolbar and click on it to 'Select Data' command. Now you have an open dialog box 'Select Data Source'. Immediately turn off the 'check box' for 'Column 1' on this dialog box because it does not want to show up on an Excel Chart.

change source data on excel chart 

Step 3.

The next step is on the left side of the dialog select 'Legend Entries (Series)' text 'Column 2', and then click your mouse on the 'Edit' button in the right part of the dialog in the 'Horizontal (Category) Axis Labels'. You opened the dialog box 'Axis Labels' on which click the button for selecting the range of cells the horizontal 'X axis' of the Graph/Chart of Excel.

choose axis label range in excel chart

Opens a new dialog box, select the range of data in the first column 'Column 1' and then click again on the button for selection to return to its original state. Now the situation is as shown below.

How to change the data range for the horizontal X-axis on the chart Excel

Step 4.

After clicking the OK button, now returns to the dialog 'Select Data Source', you will see the changed data for the horizontal X-axis Excel Chart. Click the OK button.

Changing the data for horizontal X-axis on an Excel chart

The next step is to change the range of values ​​on the vertical Y-axis Excel Chart. Click the double-click mouse the value in the vertical position Excel chart. There was a box 'Format Axis' in the right part of the Excel workspace window. You notice which all the actions you need to do (order numbers) in range of values ​​on the vertical axis Excel Chart. In Excel 2013 changes the Y values ​​do not differ much from the change in Y axis in Excel 2007.

How to change the range of values ​​on the vertical axis Excel chart 

By order of the numbers set the following values​​:

No 4. 'Bounds-Minimum' 55.0
No 5. 'Bounds-Maximum' 65.0
No 6. 'Units-Major' 1.0
No 7. 'Units-Minor' 0.2

Step 5.

Finally, the Chart in Excel looks like the image below. You still remains further design the look of Excel Charts, eventually removing the name below it, change the color of the columns and the like.

Maked a Chart in Excel

Post related for Chart in Excel.
- How to create a Chart in Excel - Basic Tutorial Example