I often use Excel for charts, including project management charts. Ideally, I would like two or more adjacent cells in the same row to show an unbroken bar, slightly shorter than the height of the cells. I would like this bar to be shown conditionally, based on information elsewhere in the spreadsheet.
For example, if I put a "3" in a column indicating a 3-month task, I would like the next three cells to the right to contain this continuous bar. If I change the number to "4," I would like the bar to go across 4 cells. If this isn't clear, I can work up a quick example. I know how to do the conditional formulas and conditional formatting; it's the default formatting in Excel that I can't seem to override to make a bar continuous.
Apparently I cannot insert graphics into a cell. Also I cannot find a font with a solid bar as a substitute. But even if I could, the solid bar would not be connected between cells. But if I could remove the default margins so that text in a cell would touch the cell borders, then I might find a close-enough font, or even use a bunch of equal signs, to fake a continuous bar.
I'm open to suggestions how to accomplish this effect. I've considered VBA code that manipulates the length of rectangle shapes, but I'd rather keep it simple and use fonts and formats and formulas if possible.