Create Weekly or Monthly Progress Chart in Google Doc Spreadsheet [Ultimate Tutorial]
Every systematic job will be based on a meticulous job schedule. But to achieve the goal, the schedule is not enough. We must strictly monitor the progress and implement the schedule. Progress of the job should be strictly monitored and adjust the schedule, if any lag found.
We can use several method to assess the progress of a scheduled job. Using charts are one of the method to visually assess the progress of a scheduled job. This is an ultimate tutorial the elaborate each and every aspect of creating a progress chart report. We are just creating a progress chart report. But on course, you will learn lots of aspects in creating a Chart.
What You are Going to Learn:
- Create charts in Google Doc Spreadsheet.
- Create *Combo aka Combination Charts in Google Doc Spreadsheet – Combo charts are the combination of line charts as well as bar or column charts.
- How to implement secondary axis means secondary “Y” axis in Google Doc Spreadsheet.
- How to Create an “S” Curve in Google Doc Spreadsheet – The term “S” curve generally uses as almost all schedule using line charts looks like in an “S” shape.
- Formatting of Charts like labeling, coloring etc.
- Finally and of course, How to Create a Monthly Progress Report Using Google Doc Spreadsheet – You can create daily, monthly or weekly progress report in the same way.
Why We Are Using *Combo Charts Here?
Because we have to show monthly schedule and monthly progress as well as cumulative schedule and cumulative progress. We are going to use bar / column chart to show monthly schedule and progress. For cumulative schedule and cumulative progress we are going to use line chart.
Why We Are Using Secondary Axis Here?
Because we have to show monthly progress / schedule as well as cumulative progress / cumulative schedule.
Before going to the steps to create a progress chart in Google Doc Spreadsheet, see the finished chart view above.
Type the sample data shown below in a blank Google Doc Spreadsheet.
Select the whole data.
Insert > Chart and move to “Chart” tab and select “Line” and the “Combo Chart”.
Then insert. Then click on the chart and from the drop down menu select “Move to own chart”. The chart will be moved to a new sheet. Now we can easily edit the chart without any distraction.
The next step is to add the respective series to secondary Axis. We will move “Cum. Target” and “Cum. Achieved” to the secondary axis. Click on the respective series and select the “Right Axis” button.
Now we have to change the series type. The default one may be not as per your requirement. You may need to change line chart to column or vice versa. To change series type from line to column or column to line in Google Doc Spreadsheet go the chart edit mode. Click the “Advanced edit” menu on the top. Under the “Customize” tab scroll down to bottom until you see “Series”. Select the series and change the type. What I mean is “Cum. Target” and “Cum. Achieved” should be the type “Line”. “Monthly Target” and “Monthly Achieved” should be “Column”. Then “Update”
That’s it. You have just competed your chart. Now change chart title and axis name.
This way you can successfully create daily, weekly, monthly progress chart or curves in Google Doc Spreadsheet. Hope you understand the complete steps. For any clarification, please feel free to write to use or post in the comments below.
About Article Author
Earlier we have learned how to create a Line Graph or Line Chart using Google Doc Spreadsheet. In this Google
Earlier we have posted a complete tutorial about creating line chart in Google Doc Spreadsheet. Now in this post we
It is very simple to convert a Google Doc Spreadsheet to Excel or PDF file format. Still we write this
Google Doc gets add-on support! Get new fonts, style sheets, functions, templates and more additional features in the form of
When you have a long range of data arranged in row wise and want to change it into column wise,
Duplicate contens can be appeared on your data due to typo graphical errors, careless entry or while applying copy and