If I have a row (5 colums) that indicate 0 to 100 % Like this that show 40% (green) and 80% (blue). Is it possible to fill the 5 colums with a color, and show maybe 66%. Row A, B, C and so on, have nothing to do with each other.

enter image description here

OPDATE If looking at Sparklines, how can I then combine these two, into one ? enter image description here

  • it's difficult with five rows, could be easier with just one. Since Excel 2010 you can use sparklines – Máté Juhász Mar 21 '18 at 12:54
  • 1
    Is there any reason that you are not just using a bar chart? – Panomosh Mar 21 '18 at 12:55
  • If you insist on making this using the cells in Excel though, which seems bizzarre, you cannot "half" fill a cell. So you are going to have to simply spread your graph over more rows.1 cell would be 2%, to get 66% you fill in 33 cells out of 50. – Panomosh Mar 21 '18 at 12:57
  • Hi Máté thx. i will try to look at that :-) Panomosh Yes and No, and maybe it's because I haven't looked more into it, but I need some layout that need to match the row as showed, because I need some text and so on, over the colums for the A and B row. – Thomas Bøg Petersen Mar 21 '18 at 13:00
  • 1
    "how can I then combine these two, into one ? " - if you need it so big, then just use a chart. There you can combine bar and line – Máté Juhász Mar 21 '18 at 13:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.