Email:      Pass:    Pass?


Advertisements


Free Excel Forum

Diagonally Dividing Individual Cell

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

how could divide one single cell in diagonal direction ?? without using line from drawing tool.


Similar Excel Video Tutorials

Helpful Excel Macros

Create a Line Chart with a Macro in Excel
- Create a line chart in Excel with this macro. This allows you to quickly and easily create line charts and graphs from
Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary
- This macro in Excel allows you to display or show a particular comment in Excel. This will make the desired comment vis
Send Emails through Outlook using Email Addresses from Excel and text from Word
- This macro allows you to send an email to a list of recipients through excel. The email will be sent through Outlook an
Count The Number of Words in a Cell or Range of Cells in Excel - With User-Specified Delimiter / Separator - UDF
- UDF to count the number of words in a cell or range with a user-specified delimiter. This means that you can tell the f
Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and workshe

Similar Topics







How do I paste text from a column into a diagonal line of cells (i.e. A1, B2,
C3, etc.)? Additionally (and this may be related), how do I get the cursor
to move to a diagonal cell after an entry? (as opposed to down or to the side)



I am creating a report that has to show the number of new customers and the dollar value those customers brought in. We would like to have the cell appear with a diagonal split so the # of new customers is in the top left and the $ is at the bottom right with a diagonal line between the two. Is this possible? if so, how can I do this?


Steps to duplicate:

(1) Draw a new forms button in Cell A8
(2) Format Cell A10 with 45 degree diagonal orientation
(3) Enter any text into cell A10
(4) Hide cell A10

The button from Cell A8 disappears. You can still click it. You can check the properties programatically and it is still set to visible. But you can't see it.

This appears to happen with all of the rows above the hidden diagonally formatted row, but I have not tested extensively. Unfortunately, the workbook I am using has several hidden diagonally formatted lines and it cannot be made to function in 2007 for that reason. Possible solutions would be replacing the diagonal formatting with images, or using vba to change the format before hiding the row, and restore before unhiding. Not pretty.

Any suggestions?




I need a formula to add diagonally. I know I could add the sum of each cell (A1, B2, C3, etc.), but is there a way to write a formula that would achieve this and can be copied over to the next column? I've tried to think of a way to do it, but have been unsuccessful.

ADD DIAGONAL.jpg

Hi

I need to shade 1 half of a cell diagonally. So 1 diagonal half blank and the other diagonal half shaded.

Is this possible? I am using version 2003

thanks

dan


Is there a way to split a cell diagonally to have text on both sides of the diagonal, for example, the top left hand corner of a table. The bottom of the diagonal denotes the first column of the table and the top denotes the first row. Any ideas?


Within a single cell, is it possible to format a diagonal line with the area below the diagonal a different color than the area above the diagonal?


Hi all,
I have a spreadsheet onto which I have pasted several pictures as illustrations. I need to use the "lines" tool in order to draw arrows between text and images, but can't find the line drawing tool, nor the toolbar. F1 help just says to click on an existing line or drawing object in order to activate the drawing tab on the ribbon. Er...if I had one already I wouldn't need to make one myself..!
Am I being really dim? Where do I find the "line" tool?

TIA


Hi,

I have a line chart with 2 axis. I want to show how much a number of the vertical axis is worth on the horizontal axis, by drawing a line that goes from the first point, then passes thru the line, and then falls on the second point.

It was fairly simple to approximate this by drawing the lines manually with the drawing tool. However, this is inaccurate, slow, and resizing the chart messes it all.

So my question is, is there a tool that provides this feature somewhere in any versions of Excel or in Office?


Occasionally I need to put big color text, something like: "PAID" or
"CONFIDENTIAL" or "CANCELLED" diagonally on certain spreadsheetS.
How can I put it diagonally rather than only horizontally or vertically.
Thanks.



Hi,
I believe the only way this could be achieved is using a drawing
object(s) i.e. triangle. You could colour the cell and then superimpose a
triangle over the cell (or use two triangles).

For a single cell this might be an option but for multiple cells it's not
(obviously) very practical.


"Andyfishing" wrote:

> I need to colour a cell that is split diagonally with 2 seperate colours?
> Excell 2003.



Anyone out there know a way to split a single excel cell diagonally in order
to have it contain 2 pieces of information?





The default behavior for drawing, for example, a connector line is that once you've drawn the first line, the "tool mode" returns to the regular cursor. This is not ideal for drawing diagrams with many connectors, as it necessitates moving the mouse out of the field of play and clicking a few times before drawing the next connector.

PowerPoint for Windows has "lock drawing mode," which changes the behavior to normal editor behavior, where your selected tool stays selected.

The internet is mum as to an equivalent in Mac 2011. Anyone know how to deal with this?

Thanks!

Hi there,

Is there any quick way to split a cell diagonally (i.e have item number/item reference in the same cell but splt diagonally by a line).

Thanks,

Stevie


Hi

Is there a way of adding a line to a graph (without using the drawing tool). The problem I have using the drawing tool (adding a line), is that if my scales changes drastically the line doesn't accommadate it.

I also don't wish to add or use alternative date. Just a simple line that moves according to my scales

Thanks in advance.


In Excel , how do I create a border line that is 45 degree or diagonal? I am trying to make a 3-d table effect where the heading look like it is going out of the computer (not related to chart function).

I attached an example file of what I am trying to do. I wasn't able to figure how it was done in filename sample.xls. In the sample.xls, when I selected Format Cells --> Border; I saw that the author did NOT make use of diagonal line but just vertical line but the border of the cell look diagonal in the spreadsheet.

Link to sample.xls
http://www.avsforum.com/avs-vb/attac...7&d=1235418297


Thanks for your time & help!

WinXP with SP2
Office 2003


hi guys,

after excel formula to work out diagonal measure of rectangle. Eg, 100mm high by 160mm long = 188.88mm from one corner to other corner diagonally.

Any help is appreciated

Thanks Mal




Hi everyone,
I am trying to get my formula to reference directly to the right of the look up value but it keeps returning the diagonal value that is located to the right and up one cell. Can someone steer me in the right direction for a fix?
I am pretty new to excel so I may be approaching this wrong.

excel 1.jpg
excel 2.jpg

Thanks

Our IT dept just forced us (kicking and screaming btw) to convert to Office 2007. In the old version we used the excel drawing tool bar extensively, which was located at the bottom of the screen. In 2007 version, can I create a special Drawing tool bar that stays displayed in the same location?


Want to set up macro that does this...

if A2 and A6 are the same then take the cells below and divide, so A7/A2 and have it go in specified cell.

The add onto above can it be a range so A2:R2 and A6:R6 and having it do the division formula above.

So A2 = A6 so divide B2= B6 so divide but C2 C6 but instead D2 = C6.


I know how to put a diagonal line into a cell, how do I put a value in the one side of the diagonal and another value into the other side of the diagonal? Is this even possible? Thank you!


im not too experienced in drawing graphs in excel. here is what im trying to do.

y-axis:
100 - 0, at increments of 10

0.000 000.0
0.092 004.3 003 008
0.126 005.0
0.172 008.0
0.216 016.0
0.287 021.0
0.392 030.0 029 049
0.536 041.0
0.643 065.0
0.732 084.0 000 089
0.879 099.0 090 100
1.000 100.0 100
1.200 100.0
1.366 100.0

PROBLEM 1: i want to have a gridline at every x-value (column 1), not at some scaled amount.

PROBLEM 2: i want to draw a line from 100 to 0, making a perfect diagonal line.

PROBLEM 3: i want to draw points, not lines, that correspond with the x-axis (column 3)

i dont have trouble graphing 1 line, but i dont know how to solve these more advanced problems.


I have been using 2007 for about a year now and I'm not really sure it's an improvement (yet). Some stuff is nice, but:

I really really really miss the drawing toolbar.

Now i'm in the middle of a project and I want to start doing some cool shadow boxes and lines and other stuff.

I'M STARTING WITH A BLANK SPREAD SHEET so PLEASE don't tell me to start by clicking on some drawing image to get to the tool bar! I got no images to click on! (Also, I find it really annoying that I must click on a drawing image to make the drawing image tools appear! How do you START making a drawing image!!?? HOW LAME!).

I really wish Bill Gates would have talked to me before he pulled the trigger on this one.

Is there any way to get the drawing tools to show on the ribbon?

Or is there a shortcut to it I can create??

HELP!


I'm trying to label cell A1 in an Excel spreadsheet so that the row name is
identified as well as the column name in this same cell A1, separated by a
diagonal. I can draw the diagonal, but how do you get the row name to appear
in the upper right of the cell and the column name to appear in the lower
left?
--
SgtBob





I am not a programmer, but am quickly realizing how amazingly helpful developing the skills of one can be. For now, however, I have a problem that I personally lack to the know-how to solve, and I'm hoping someone here will be able to figure this out for me.

My goal is somewhat difficult to describe, but I will try. Essentially, I have an image which i have reduced to a mathematical representation of light intensities. We can consider each cell in my spreadsheet as a pixel, the value within the cell corresponding to how much light that pixel it took in during an exposure. There is a trend along the pixels that i would like to isolate as exactly as possible: a diagonal line, not quite straight from the bottom left corner to the top right.

What I would like to do, if possible, is to treat each cell in my spreadsheet as a point on a coordinate plane, and to use some type of formula or macro to give me a line of best fit using the positions of the highest valued cells as the data points in my extrapolation.

The tool I'm looking for would take data organized like this:


1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 200 1 1 1
1 1 1 1 1 1 200 1 1 1 1
1 1 1 1 1 200 1 1 1 1 1
1 1 1 1 200 1 1 1 1 1 1
1 1 1 200 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1

And give me an equation of the form y=1x + b (describing where to find the maximum values among the cells), although my actually data will need to be fit to a higher order polynomial.

Once I can do this, I will also need a way to take perpendicular sums automatically along the line of best fit at distance of two pixels in both directions and a width of one pixel. You can imagine drawing a rectangular box perpendicular to the line of maximum values and adding the proportions of each cell enclosed by that box. This means that for the example above, i would get 209 for all five points of interest: the maximum value plus the two values of one in the upper left perpendicular direction, the two values of one in the lower right perpendicular direction, half the values of the two cells neighboring the exactly perpendicular cells and a quarter of the outermost cells touched by our imaginary pixel box.

The following image may be helpful in clarifying what I'm looking for. The red bar represents the imaginary box containing perpendicular pixel sums, where the green beam is the line of best fit derived from my maximum values. Attachment 337419


Also, here is a snippet of my actual data to experiment with in solving these strange and exotic problems Attachment 337420


I hope this wasn't all terribly confusing. Please let me know if anything in particular needs to be expanded on.

Thank you very much.