Progress Bar for 3 different data

[erhanm]

Hi,
I want to create a data progress bar includes these 3 data bar in one bar. Is it possible to do it without using macros ?

Thank you.

[kersplash]

You could do it with a stacked bar chart.

Capture.JPG

[AliGW]

How should the bar look? Multi-coloured or a solid colour that averages progress?

[sandy666]

something like this one?

[erhanm]

Bar should be in a cell not in a chart. Three type data will be shown with its own color.

[erhanm]

Progress bar should be %100 not more than like %140. Is it possible to show it in a cell and nested (using one horizontal, one vertical pattern and one solid color).

Thank you.

[sandy666]

IMO, if you want progress bar in single cells (like in your example) you'll need vba

[kersplash]

Just use a chart and delete all the text components. Turn it to horizontal and the resize it so it fits in a cell.