Comment on Looking for a way to make a proportional timeline out of an Excel or CSV file

paddythegeek@lemmy.ca ⁨2⁩ ⁨days⁩ ago

What you’ve found is probably sufficient if you have a small amount of data or only need this type of display rarely.

Another approach to solving this would be to create a date table listing all of the date units between the start and end of your timeline and represent those as having no value. When you add your values to this data set you ensure proportional spacing, as every date unit in the set will be represented. This type of work is much easier to do using Power Query, if you have access to that Excel add in.

source
Sort:hotnewtop