A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Splitting cells / diagonally displaying cell data



 
 
Thread Tools Display Modes
  #1  
Old September 16th, 2003, 04:32 AM
Robb Lassu
external usenet poster
 
Posts: n/a
Default 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  
Old September 16th, 2003, 06:34 AM
Matt
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.