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.
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'.
Now we have created an Excel Chart like this one in the picture below.
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.
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.
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.
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.
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.
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.
Post related for Chart in Excel.
- How to create a Chart in Excel - Basic Tutorial Example