If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Splitting cells / diagonally displaying cell data
You don't have to constrain yourself to consecutively
using every cell as they are laid out on the sheet. If you consider a 2x2 block of cells as one cell, enter the desired information in the upper left and lower right cells. Next run a diagonal line through the other two cells, and you have accomplished a similar look. For a cleaner look, white fill all of the cells of concern and add a border that goes around the 2x2 block so that it appears as if it is only one cell. |
Thread Tools | |
Display Modes | |
|
|