A progress chart is a visual tool used to track the completion of a specific goal or task. It most often shows changes in values in relation to progress, allowing you to quickly grasp the pace and effectiveness of your activities.
Chart properties
Stracked - a cumulative chart can show several values, one after another.
Stracked 100% - the chart shows the values as a percentage of each value in the total, which helps you see how each value affects the entire category in relation to its proportion.
Data from table
Date retrieved using the lookup function
Date retrieved using the lookup function. When using a stacked or stacked 100% chart in the value, you need to specify either an array of values or a range of cells.
Series - The progress chart has only one series.
Name - is the name of the series, which will be displayed in the legend and in the label when you hover over a value on the chart.
Data - if the data comes from an external table or list, apply a lookup formula to fetch the correct records. In the case of a non-cumulative chart, one record will be linked, the first one that meets the search criteria. When the data is entered directly into the field or given as a cell address, you can leave the field blank
Value - if a formula (lookup) is used in the “Data” field, enter a column from the associated record. You can also enter the value manually or provide the address of the cell.
Color - the color the bar will have on the chart
Data labels - labels that help the user read the values on the chart:
- Tooltip - when you hover over an item, its value will be displayed
- Fixed - values are displayed directly on the chart
- None - the labels will not be displayed
Target - position of the marker marked on the chart
Example 1.
The graph shows the progress of project Z. On the Y-axis are values from 0 to 100, where the bar represents the progress of the project. For example, if the bar shows a value of 65, it means that 65% of the project has already been completed.
The data values on the chart are retrieved using the lookup function, which points to the relevant records from an external table. It is important to note that when using the lookup function, only the first record will be linked.
Thus, the progress chart allows you to easily visualize how much is left to reach the full goal and quickly assess the pace of the project.
Progress chart
Example 2.
The graph shows the progress of project Z. On the Y axis are values from 0 to 100, where each bar represents the percentage progress of the project. For example, if the bar shows a value of 40, it means that 40% of the project has already been completed. The target (target) value is set to 100, which means that the full progress of the project is 100%.
The value on the chart is taken directly from the spreadsheet cell.
0 Comments