Do you want to create a visually appealing progress chart in Google Sheets to track your job progress? Look no further! In this tutorial, I will guide you through the process of creating a weekly or monthly progress chart in Google Sheets, giving you valuable insights into various aspects of chart creation.
Why Should One Use a Progress Chart to Track Job Progress?
A well-planned job schedule is important, but it’s not enough on its own. To successfully complete a job, you need to closely monitor the progress and make necessary adjustments. One effective way to visually assess progress is by using charts. In this tutorial, we will focus on creating a progress chart report in Google Sheets, covering everything you need to know.
What Will You Learn by Creating This Progress Chart in Google Sheets?
By creating this progress chart, you will learn the following:
- How to create a chart in Google Sheets.
- Creating combo (combination) charts by combining line and column charts.
- Adding a secondary axis (secondary Y-axis) to the chart.
- Creating an S curve to represent the progress.
- Creating a monthly progress report.
Why Are We Using a Combo Chart Here?
We are using a combo chart in this tutorial because we want to display both the monthly schedule and progress, as well as the cumulative schedule and progress. We will use column charts to illustrate the monthly data and line charts for the cumulative data.
Why Are We Using a Secondary Axis Here?
To visualize the monthly and cumulative data properly, we need to use two axes. The monthly data, including the schedule and progress, will be displayed on the left axis, while the cumulative data will be displayed on the right axis.
Now, let’s dive into the steps to create a weekly or monthly progress chart in Google Sheets.
Steps to Create a Weekly or Monthly Progress Chart in Google Sheets
- Type the sample data shown below into a blank Google Sheets file (click here to make a copy):
| Month | Monthly Target | Monthly Achieved |
|---|---|---|
| January | 100 | 80 |
| February | 150 | 120 |
| March | 200 | 160 |
| April | 250 | 200 |
| May | 300 | 240 |
| June | 350 | 280 |
| July | 400 | 320 |
| August | 450 | 360 |
| September | 500 | 400 |
| October | 550 | 440 |
| November | 600 | 480 |
| December | 650 | 520 |
- Select the entire data range from cell A2 to E23.
- Click on Insert > Chart.
- On the Chart editor that appears on the right-hand side, select Chart type > Combo chart.
- Click on the chart, and from the drop-down menu, select Move to own sheet (optional).
- The chart will be moved to a new sheet, allowing you to easily edit it without distractions.
- The next step is to add the respective series to the secondary axis or ‘Right Axis’.
- Move “Cum. Target” and “Cum. Achieved” to the secondary/right axis.
- To change the series type, double-click anywhere on the chart to activate the Chart editor. Under the Customize tab, click the Series drop-down and select the desired type (line or column).
- Move “Cum. Target” and “Cum. Achieved” to the secondary axis using the option at the bottom of the chart.
- Customize the chart title and axis names from the customization tab.
- Congratulations! You have just created your weekly or monthly progress chart in Google Sheets.
Conclusion
By following the above steps, you can create daily, weekly, and monthly progress charts or curves in Google Sheets. Monitoring your job progress visually can help you stay on track and make necessary adjustments. The progress chart presented in this tutorial has been used successfully for many years and can be customized to suit your specific needs.
For any clarifications, feel free to post in the comments below. And don’t forget to visit Crawlan.com for more helpful articles and tutorials.
Related Charts:
- Create a GANTT Chart in Google Sheets Using a Stacked Bar Chart.
- Create Gantt Chart Using Formulas in Google Spreadsheet.
- How to Create a Site Organization Chart in Google Sheets.
- How to Add Tooltips to Org Chart in Google Sheets.
- Get a Target Line Across a Column Chart in Google Sheets.
- How to Move the Vertical Axis to the Right Side in Google Sheets Chart.
- Bar or Column Chart with Red Colors for Negative Bars in Google Sheets.
- Add Legend Next to Series in Line or Column Chart in Google Sheets.
- How to Use Slicer in Google Sheets to Filter Charts and Tables.
- Scorecard Charts in Google Sheets – All that You Want to Know.
