Add an in-cell bar graph

Question

I have a table where each query has a 'level' of a set amount of criterias, and I want to have a bar graph for each line that will allow me to see the dominant criterias clearly.

I know how to make a graph like that but I specifically want the graph to fit into the matching cells in the table.

Alternativly (not ideal but I'm willing to compromise), is it possible to make a column sparkline have a set color for each column (and not just the first and last ones)?

An illustration of what I want it to look like (A-D is the queries, a-d is the criterias):

Thank you in advance :)

Answer 1

This formula will get a list from 1 to 100 . You can also input numbers directly in cells.

=SEQUENCE(,100)

2. Then apply conditional formatting on rows.
3. Less than B2
4. Greater than B2 and Less than B2+C2

...

=F$1<=$B2

=AND(F$1>$B2,F$1<=$B2+$C2)

=AND(F$1>$B2+$C2,F$1<=$B2+$C2+$D2)

=AND(F$1>$B2+$C2+$D2)

Answer 2

It seems there is no built-in function to create a such chart in cell.

You may try conditional formatting as workaround.

Formula in F1, then set the 100 column with width 0.2

=SEQUENCE(,100)

Conditional formatting formula:

=F$1<=$B2

=AND(F$1>$B2,F$1<=$B2+$C2)

=AND(F$1>$B2+$C2,F$1<=$B2+$C2+$D2)

=AND(F$1>$B2+$C2+$D2)

Another way is use sparklines. However, there is no stacked Bar in Sparklines.

Third way is to create 4 stacked bar charts and remove all the unnecessary parts.

Answer 3

It worked perfectly!! Thank you SO MUCH!

Answer 4

You are welcome:)