7/30/2023 0 Comments Vmaker roadmapOnce you perform the steps above, your newly formatted roadmap table will look like this: Click on Merge horizontally from the menu that subsequently appears. Go to Format → Merge cells on the Google Sheets ribbon. This will select all the cells of your roadmap data table. Click on the upper left cell of your data table (in our case, cell C4), and then press and hold while dragging the cursor over the rest of the cells contained within the horizontal and vertical axes of your roadmap. Follow the steps below to do this for all your rows at once: Horizontally merge cells for each of your data rows – To turn a specific row into a swimlane, you will need to merge all the row’s cells under the timeband header (i.e., those defined by the horizontal and vertical axes of your roadmap). By doing so, you ensure the selected rows are equally sized. Set up horizontal swimlanes for each of your roadmap’s main components.Īdjust row width - Select the rows that contain the items listed at Step 1 (keep CTRL pressed while clicking on each row’s numeric indicator at a time), and then drag the up-down handle to increase their width to the intended extent. The horizontal axis - it lays out the timeline against which you will represent the details associated with each of your roadmap’s major steps.ģ. The vertical axis – it represents the major components of the overall process that you want to map out So, we inserted two timebands (in months and quarters, respectively) that are highlighted with alternating colors for better differentiation.Īt this point, you will have outlined the two main dimensions of your roadmap: In our example, we wanted to use multiple time reference sets for the tasks and milestones that will be included in our roadmap. It is against these time units that you will mark your roadmap’s most important activities or events. Use the top row of your spreadsheet as a horizontal axis to add the time increments (weeks, months, or quarters) that will define the timeline band of your roadmap. In our example below, we listed the main four stages of the product roadmap we want to build.Ģ. Set a timeline at the top of your spreadsheet. These will make up the vertical axis of your visual.ĭepending on the type of data you want to illustrate, these elements may refer to phases, processes, teams, or product features. In the newly opened spreadsheet, list the major components of your roadmap’s workstream in a column. Enter the main components of your strategic plan in Google Sheets. Since Google Sheets doesn’t have any incorporated pre-made roadmap templates that you can customize, you will need to build one from scratch by opening a new blank spreadsheet and following the steps below.ġ. How to manually make a roadmap online with Google Sheets
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |