These values set the color of the alternating bars in the bar visualization. ![]() The first argument to SPARKLINE is a dynamic value, calculated by subtracting the project’s start date from the current date: int(today())-int( projectStart) Customizing your TimelinesĮach SPARKLINE function takes arguments for color1 and color2. This gives you a visual display of how well the project is keeping on track to its timeline. The burn down visualization shows the days that have been burned through the project. The week-by-week visualization uses a clever little formula to make an array of number incrementing by seven as the first argument to SPARKLINE to display alternating colored bars for each week of the project's duration. On the example template, there are a couple other features: a week-by-week ruler and the burndown visualization. The value for "max" is the difference between the start and end of the project in days. The SPARKLINE function then makes two bars, one which is colored "white", as to be invisible and the other which is colored blue (by default) or any color you choose by setting "color2". The SPARKLINE formula for each task visual looks like this: =SPARKLINE( To create the visualization, we are going to use “ bar” for the value of “charttype.” Then we get a little bit clever with colors to show the start and end dates of each task. To learn more about how the sparkline feature works, check out these sparkline examples. ![]() Sparklines are essentially just little data visualizations in spreadsheet cells. ![]() This keeps the project task visualization in the same place as all the important details about each task such as the RACI assignments or progress updates. ![]() There are other Google Spreadsheet Gantt chart examples that use the Chart feature as the visualization.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |