Help with a Graphic

madimar

New Member
Joined
Jul 16, 2014
Messages
6
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.

Total OffersW1W2W3W4W5W6W7W8W9W10W11W12W13W14W15W16W17W18W19W20W21W22W23W24W25W26W27W28W29W30W31W32W33W34W35W36W37W38W39W40
Sofia274490448433474458409363350355389286533573565405504428503526489514533478455452461391375373483324331348416471482590661370
Sofia (Stud. grad)266840432846365342455042354147325918412966893646364554382532352419192558143209692
Varna20414139653530352521322358734741424551585873603558847166605167553439725648606130
Burgas17322949352537192416151551415342472543364143304232372437383036273733453636332810
Plovdiv34913476895541621151511111017121412141199136914491111152114168
Veliko Tarnovo287378601077270325545415178837669855371616070605557787357668256464455766146794717
Targoviste0000000000000000000000000000000000000000
Pernik0000000000000000000000000000000000000000
Sliven00300211430185079839324741055742454453461
Stara Zagora453671941251131512155910581013131051188710107101318201422100
Razgrad0000000000000000000000000000000000000000
Ruse2340111000221097743457107784633252597611833
Shumen0102002120101232321122231120013011122000
Other11478107139140421016272539247982257294812516118261119291220561953192936363536

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
What information do you think that Chart gives to the reader? A Chart requires values on the y axis to show relative size, not labels like W1, W2 etc. For your image you might as well just format the cells in your original data.
 

madimar

New Member
Joined
Jul 16, 2014
Messages
6
The answer to your question - I don't know . I am an Intern at a big company and they made me do it . For what purposes I can't tell you. It has been sent from one person to another until it hit me :) . Thank you for the cell formating idea but they insist for a graphic. I know a chart requires values on the axis , that is why I am so hyped - I think it is impossible to make a graphic like that. That is why I turned to the Pros like you - so is it possible or they just sent me for "green chavier"?
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
I would ask the powers that be what they really want. I have no idea how one would create a Chart that looks like your image, ie no scaling.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,368
Messages
5,528,274
Members
409,813
Latest member
robyrux

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top