October 14, 2014
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:
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.
June 25, 2016
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.
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.
Most Users Ever Online: 57
Currently Online: Catalin Bombea
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Mohamed Rehan Memon
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas