Splitting cells / diagonally displaying cell data
I have a two groups of data that will have six categories. Each category
will be assigned a date in columns. The difficult part is that one row
needs to relate to each of the dates and ideally I would like the dates
displayed in one cell divided be a diagonal line.
All of this is basically an ongoing project that I will need to see dates at
a glance and make sure everything is on track. The actual information is
confidential but I have related this project to some house repairs.
This is the best example I can think of... (imaging this is an Excel chart)
i.e.
Interior of house
Framing Drywall Trees
Exterior of house
Fencing Sod Siding
Carpenter Jan 10 Jan 14
Jan 11 Jan 15
Gardener Jan 10 Jan 14
Interpreted this would mean that the Carpenter is doing Framing on Jan 10
and Fencing on Jan 11.
Can this be done?
|