Hello guys ,
I have been using Excel for different purposes in the past but now I am troubled by a graph I have to do.
I have a table( which is below the picture) and I have to make a model looking like the picture where I have colored bars which must be in the graph one way or another. I imagined it like this but I am open for any other solutions.Please help me do this in Excel or sugest me any way of doing this PLEASE.
<tbody>
</tbody>
I have been using Excel for different purposes in the past but now I am troubled by a graph I have to do.
I have a table( which is below the picture) and I have to make a model looking like the picture where I have colored bars which must be in the graph one way or another. I imagined it like this but I am open for any other solutions.Please help me do this in Excel or sugest me any way of doing this PLEASE.
Total Offers | W1 | W2 | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | W22 | W23 | W24 | W25 | W26 | W27 | W28 | W29 | W30 | W31 | W32 | W33 | W34 | W35 | W36 | W37 | W38 | W39 | W40 |
Sofia | 274 | 490 | 448 | 433 | 474 | 458 | 409 | 363 | 350 | 355 | 389 | 286 | 533 | 573 | 565 | 405 | 504 | 428 | 503 | 526 | 489 | 514 | 533 | 478 | 455 | 452 | 461 | 391 | 375 | 373 | 483 | 324 | 331 | 348 | 416 | 471 | 482 | 590 | 661 | 370 |
Sofia (Stud. grad) | 26 | 68 | 40 | 43 | 28 | 46 | 36 | 53 | 42 | 45 | 50 | 42 | 35 | 41 | 47 | 32 | 59 | 18 | 41 | 29 | 66 | 89 | 36 | 46 | 36 | 45 | 54 | 38 | 25 | 32 | 35 | 24 | 19 | 19 | 25 | 58 | 143 | 209 | 69 | 2 |
Varna | 20 | 41 | 41 | 39 | 65 | 35 | 30 | 35 | 25 | 21 | 32 | 23 | 58 | 73 | 47 | 41 | 42 | 45 | 51 | 58 | 58 | 73 | 60 | 35 | 58 | 84 | 71 | 66 | 60 | 51 | 67 | 55 | 34 | 39 | 72 | 56 | 48 | 60 | 61 | 30 |
Burgas | 17 | 32 | 29 | 49 | 35 | 25 | 37 | 19 | 24 | 16 | 15 | 15 | 51 | 41 | 53 | 42 | 47 | 25 | 43 | 36 | 41 | 43 | 30 | 42 | 32 | 37 | 24 | 37 | 38 | 30 | 36 | 27 | 37 | 33 | 45 | 36 | 36 | 33 | 28 | 10 |
Plovdiv | 3 | 4 | 9 | 13 | 4 | 7 | 6 | 8 | 9 | 5 | 5 | 4 | 16 | 21 | 15 | 15 | 11 | 11 | 10 | 17 | 12 | 14 | 12 | 14 | 11 | 9 | 9 | 13 | 6 | 9 | 14 | 4 | 9 | 11 | 11 | 15 | 21 | 14 | 16 | 8 |
Veliko Tarnovo | 28 | 73 | 78 | 60 | 107 | 72 | 70 | 32 | 55 | 45 | 41 | 51 | 78 | 83 | 76 | 69 | 85 | 53 | 71 | 61 | 60 | 70 | 60 | 55 | 57 | 78 | 73 | 57 | 66 | 82 | 56 | 46 | 44 | 55 | 76 | 61 | 46 | 79 | 47 | 17 |
Targoviste | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pernik | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Sliven | 0 | 0 | 3 | 0 | 0 | 2 | 1 | 1 | 4 | 3 | 0 | 1 | 8 | 5 | 0 | 7 | 9 | 8 | 3 | 9 | 3 | 2 | 4 | 7 | 4 | 10 | 5 | 5 | 7 | 4 | 2 | 4 | 5 | 4 | 4 | 5 | 3 | 4 | 6 | 1 |
Stara Zagora | 4 | 5 | 3 | 6 | 7 | 1 | 9 | 4 | 12 | 5 | 11 | 3 | 15 | 12 | 15 | 5 | 9 | 10 | 5 | 8 | 10 | 13 | 13 | 10 | 5 | 11 | 8 | 8 | 7 | 10 | 10 | 7 | 10 | 13 | 18 | 20 | 14 | 22 | 10 | 0 |
Razgrad | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Ruse | 2 | 3 | 4 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 2 | 2 | 10 | 9 | 7 | 7 | 4 | 3 | 4 | 5 | 7 | 10 | 7 | 7 | 8 | 4 | 6 | 3 | 3 | 2 | 5 | 2 | 5 | 9 | 7 | 6 | 11 | 8 | 3 | 3 |
Shumen | 0 | 1 | 0 | 2 | 0 | 0 | 2 | 1 | 2 | 0 | 1 | 0 | 1 | 2 | 3 | 2 | 3 | 2 | 1 | 1 | 2 | 2 | 2 | 3 | 1 | 1 | 2 | 0 | 0 | 1 | 3 | 0 | 1 | 1 | 1 | 2 | 2 | 0 | 0 | 0 |
Other | 1 | 14 | 7 | 8 | 10 | 7 | 13 | 9 | 140 | 42 | 10 | 16 | 27 | 25 | 39 | 24 | 79 | 82 | 25 | 7 | 29 | 48 | 125 | 161 | 18 | 26 | 11 | 19 | 29 | 12 | 20 | 56 | 19 | 53 | 19 | 29 | 36 | 36 | 35 | 36 |
<tbody>
</tbody>