Ask Your Question

How do I create a progress chart worksheet? [closed]

asked 2015-12-17 18:36:40 +0100

psilver1 gravatar image

updated 2020-08-28 06:35:04 +0100

Alex Kemp gravatar image

I have a monthly workbook that tracks our agent's appointment progress each day with its own worksheet tab. Each day it tracks appointments kept, selling days used, appointments tracking total for month-end, their goal they established at the beginning of the month, and the variance between what they are tracking and what their goal is. I would like to create an additional sheet within the same workbook that allows me to see the agents' progress against each other, so I can see trends through the month.

I am having difficulty wrapping my head around getting the appointment-kept data pulled from each day's sheet and having it represented in chart format in the progression worksheet. At this time, I only want to chart progress on the appointments kept data.

I've researched some of this and have come across consolidating data from multiple sheets into one sheet, but that has confused me further, since I have never built a workbook that consolidates data.

Version: Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-28 06:35:40.488200

1 Answer

Sort by » oldest newest most voted

answered 2015-12-24 10:42:53 +0100

pierre-yves samyn gravatar image

updated 2015-12-24 10:46:46 +0100


You can perhaps get what you are looking for with conditional formatting. The FAQ on the wiki presents step by step two possibilities with screenshots and example spreadsheets:


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-12-17 18:36:40 +0100

Seen: 193 times

Last updated: Dec 24 '15