Step 4: Changing Label Position on the Horizontal Axis Therefore, you will get the following chart.In the Axis Options tab, select the Categories in reverse order. To reverse the order double-click on the Category Axis, and the Format Axis task pane appears.On the Category Axis (in the chart the Vertical Axis), the “Task-C-4” takes a position at the top, but the “Task-A-1” should be on the top.To do this, you have to follow the following process. In this step, we are going to reverse the category axis order. As a result, you will get the following chart.Afterward, the Axis Labels window will appear, where Task Name column data must be entered.Next, click on Edit from the Horizontal (Category) Axis Labels.Then, you will get the Edit Series window, where you have to enter the new data series column name on the Series name box and select values on the Series values box.When the Select Data Source appears, click on Add to another data series as shown below.Next, right-click on the chart and click on Select Data to add other data series on the X-axis and Y-axis.Make the chart a little bit wider to get more space to work. By default, you will get the following chart.Now, in the Insert tab, click on the drop-down arrow of the Insert Column or Bar Chart from the Charts group.First of all, select the range of the cells D4:D16.To do this you have to do the following process. Now, we are going to insert a stacked bar chart for our dataset. In the Progress column, we enter each task’s progress status.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |