Now the Axis label range needs to be added, the Axis label popup appears.
Once you click ok again, the Select Data Source window appears. by selecting from cells “C4” to “C17” and click on ok, Now “No of days” with data bars appear in chart area (Orange color).
#IT ROADMAP TOOL SERIES#
“C3”, Later in the series values, enter the “No of days” range, i.e. in that series name, enter the “No of days” column title name cell, i.e. In the select data source dialog box window, select add option in the legend entries (Series) again, you need to select the “No of days” column range, i.e. by selecting from cells “B4” to “B17” and click on OK, now start date with data bars appear in the chart area (Blue Color).Ĭlick on OK, again the Select Data Source window appears, in that you can observe Date Series added. “B3”, Later in the series values, enter the start date range, i.e. in that series name to enter start date column title name cell, i.e. Now, we need to enter each column data set of table range, edit series window dialog box appears, in that, initially select the start date column range, i.e. Select the Add option in the legend entries in the Select Data Source dialog box window (Series).
On the chart area, right-click, under that, select the option of “select data”, and select the data source dialog box window. Now, you can observe a blank chart area appears next to the table range. Go to the Insert tab and select 3-D Stacked Bar Chart. Including Key Events & Decisions, the Start Date of that event & No of days to complete it, or the duration for each event. The table contains a list of each task or milestone of the project from beginning to end with a time frame for each event. Key event or milestone, start date & time taken, or duration of a task (No of days). Initially, we need to enter the data table where it consists of three columns, i.e.
#IT ROADMAP TOOL DOWNLOAD#
You can download this Roadmap Excel Template here – Roadmap Excel Template Example #1
0 kommentar(er)
