The purpose of the worksheet is to plan the overlap dates for seasonal employees over the next 12 months. I would like to produce an in-cell graph for each employee showing their start dates, duration of service, and end dates.
There are three dates involved: first_chart_date, then start_date and end_date for each employee. Using these, I calculate for each employee the number of days until she start and the duration of time they will serve.
Using the rept() function to create the in-cell bar:
=REPT(" ",days_until_start)&REPT("|",duration_of_service)
The problem with this bar chart is that the spaces are wider than the pipe symbol, so comparisons of start and end date are skewed.
How do I compensate for the width of the space? Is there another blank character that is the same width as the pipe symbol? I tried using periods, but even that is wider than a pipe.
Hi Brian
You can try scale down the leading blank space. For example =REPT(" ",AL7/4)&REPT("|",AM7)
It will look nice as long as the zoom is at 100%
Another way is to consider using bar charts, hiding all elements except the bars.
Refer attachment.
Another try is by using the Webding font e.g. =REPT(" ",AL7)&REPT("g",AL7)
Note: There are two blank spaces between the " ". You may need to scale down AL7 if the squares are too wide.
With this font, the zoom doesn't seem to be an issue.
Hope this helps.
Sunny
