How to make a progress bar on Google Sheets?

Question

I need to make a delivery progress bar on sheets like the one on DoubleClick for Publishers. I want the bar to show the percentage of delivery of a campaign according to its start and end date. Example:

The progress is calculated as the percentage of impression goal delivered divided by the percentage of time elapsed: progress = (% of impression goal delivered) / (% of time elapsed) Delivery progress assumes an even distribution of impressions.

For example, a line item that has delivered 50% of its impression goal 50% of the way through the campaign has a progress of 100%. However, a line item that’s delivered 50% of its impression goal at the end of day 3 of a 4-day-long campaign would have a progress of: 50 / 75 = 66%

On top of that I need the progress bar to show where in the campaign I am currently (vertical grey line in the photo).

Answer 1

When I used teocrasto's formula, I got error, I probably should have changed something, but the following formula worked well for me.

=SPARKLINE(20,{"charttype","bar";"max",100})

In this example the progress bar is 20% filled. So change the number 100 to your "full" amount and 20 to whatever you want the bar to be filled. You can use cells instead of those number.

If you want to change the color of the "main" bar use this

=SPARKLINE(20,{"charttype","bar";"color1", "blue";"max",100})

It will take common "word" colors, for more precision use hexadecimal (#0000FF).

I hope this helps.