I thought I had a good idea, but I am not so sure now. I am trying to use the same concept for in-cell charts using the REPT() to make a Gantt chart. The problem I am running into is that I can't get a bar to cross cell boundaries without some white space, so it looks clunky. I have used formulas and conditional formatting in the past, which works fine, but in this case I was trying to find a method to start or end a bar in the middle of a cell. Is there a way to format to remove the white space? Or, is there another way to do it to accomplish the same result? Note that in the Excel sheet there are no gridlines, so where there are gridlines in the sample below, it is whitespace in the excel sheet.
Gantt
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:75px;"><col style="width:75px;"><col style="width:68px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]30[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="align: center"]start[/TD]
[TD="align: center"]end[/TD]
[TD="align: center"]duration[/TD]
[TD="colspan: 4, align: center"]month[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="align: center"]11/01/17[/TD]
[TD="align: center"]12/01/17[/TD]
[TD="align: center"]01/01/18[/TD]
[TD="align: center"]02/01/18[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD="align: right"]15-Oct-17[/TD]
[TD="align: right"]14-Dec-17[/TD]
[TD="align: right"]2[/TD]
[TD="align: left"]|||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]
[TD="align: right"]15-Nov-17[/TD]
[TD="align: right"]14-Jan-18[/TD]
[TD="align: right"]2[/TD]
[TD="align: left"] ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]16[/TD]
[TD="align: right"]07-Dec-17[/TD]
[TD="align: right"]20-Feb-18[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: left"] |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||||||||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]17[/TD]
[TD="align: right"]15-Dec-17[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: left"] |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||||||||||||||||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]18[/TD]
[TD="align: right"]05-Nov-17[/TD]
[TD="align: right"]20-Nov-17[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: left"] |||||||||||||||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]19[/TD]
[TD="align: right"]26-Sep-17[/TD]
[TD="align: right"]26-Oct-17[/TD]
[TD="align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]20[/TD]
[TD="align: right"]05-Oct-17[/TD]
[TD="align: right"]04-Dec-17[/TD]
[TD="align: right"]2[/TD]
[TD="align: left"]|||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]21[/TD]
[TD="align: right"]15-Nov-17[/TD]
[TD="align: right"]29-Jan-18[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: left"] |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||[/TD]
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4
Gantt
AP | AQ | AR | AS | AT | AU | AV | |
<colgroup><col style="font-weight:bold; width:30px; "><col style="width:75px;"><col style="width:75px;"><col style="width:68px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]30[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="align: center"]start[/TD]
[TD="align: center"]end[/TD]
[TD="align: center"]duration[/TD]
[TD="colspan: 4, align: center"]month[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="align: center"]11/01/17[/TD]
[TD="align: center"]12/01/17[/TD]
[TD="align: center"]01/01/18[/TD]
[TD="align: center"]02/01/18[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD="align: right"]15-Oct-17[/TD]
[TD="align: right"]14-Dec-17[/TD]
[TD="align: right"]2[/TD]
[TD="align: left"]|||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]
[TD="align: right"]15-Nov-17[/TD]
[TD="align: right"]14-Jan-18[/TD]
[TD="align: right"]2[/TD]
[TD="align: left"] ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]16[/TD]
[TD="align: right"]07-Dec-17[/TD]
[TD="align: right"]20-Feb-18[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: left"] |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||||||||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]17[/TD]
[TD="align: right"]15-Dec-17[/TD]
[TD="align: right"]28-Feb-18[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: left"] |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||||||||||||||||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]18[/TD]
[TD="align: right"]05-Nov-17[/TD]
[TD="align: right"]20-Nov-17[/TD]
[TD="align: right"]0.5[/TD]
[TD="align: left"] |||||||||||||||||||||||||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]19[/TD]
[TD="align: right"]26-Sep-17[/TD]
[TD="align: right"]26-Oct-17[/TD]
[TD="align: right"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]20[/TD]
[TD="align: right"]05-Oct-17[/TD]
[TD="align: right"]04-Dec-17[/TD]
[TD="align: right"]2[/TD]
[TD="align: left"]|||||||||||||||||||||||||||||[/TD]
[TD="align: left"]|||[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]21[/TD]
[TD="align: right"]15-Nov-17[/TD]
[TD="align: right"]29-Jan-18[/TD]
[TD="align: right"]2.5[/TD]
[TD="align: left"] |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||||[/TD]
[TD="align: left"]||||||||||||||||||||||||||||[/TD]
</tbody>
Excel tables to the web >> Excel Jeanie HTML 4