Hard Light Productions Forums
Off-Topic Discussion => General Discussion => Topic started by: Kosh on July 18, 2011, 12:00:51 am
-
I'm attempting to replicate the style used in this spreadsheet
(http://i54.tinypic.com/veucet.jpg)
but I can't seem to get it quite right with Excel, any have any suggestions?
-
Rotate your monitor onto its side. :P
-
Rotate your monitor onto its side. :P
I wasn't referring to it's tiltedness. :P
-
I'm attempting to replicate the style used in this spreadsheet
(http://i54.tinypic.com/veucet.jpg)
but I can't seem to get it quite right with Excel, any have any suggestions?
They're probably using a lot more columns than what you see and made the months grid stick out by manipulating the border rules. They either use a layout by weeks or days (probably the former) but I can't tell that just from a single screen-shot.
-
but I can't seem to get it quite right with Excel, any have any suggestions?
Yes, thankfully your answer is so detailed and precise that we all instantly knew the exact problems you had
-
Hmmm, I'm not quite sure exactly what you are trying to replicate, but I'll see what I can do.
I don't have Excel in front of me right now, but it seems to be a simple combination of heavy, colored borders and an embedded bar graph. http://www.ncsu.edu/labwrite/res/gt/gt-bar-home.html
I don't know why it's all on it's side, but I imagine there's a setting for that somewhere as well.
-
It's a Gantt chart, isn't it? I think it would be difficult to create one of those in Excel (well, obviously, since you asked for help), at least to make it look like the screenshot you posted. However, a quick search on Google ("Create a gantt chart") turns up this (http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html) among other resources - maybe give that a go?
-
It looks like all the thin lines are gridlines in excel, but the green bars are smartobjects that are drawn in. Explains why none of them are properly centered in their row.
-
See if you can convert it to a spreadsheet format.