How do I make a chart with an angled cell across the top

L

locastella

I am trying to make a chart that is similar to a mileage chart in word. Any
help on how to angle the cells?
 
S

Suzanne S. Barnhill

This can't be done in Word (you can have vertical text, but not angled), but
it can be done in Excel.
 
L

locastella

Suzanne S. Barnhill said:
This can't be done in Word (you can have vertical text, but not angled), but
it can be done in Excel.





Thanks for the answer, I can quit trying! Can you tell me how to do it in excel.
Click to expand...
 
S

Suzanne S. Barnhill

Well, the first thing you need to know is that *all* the cells in a given
row have to be angled. That's what threw me off the first time I tried it.
Select the row, then use Format | Cells | Alignment and drag the red diamond
to the desired angle (say, 45 degrees). You won't see any change in the
cells until you type something, and you won't get the full effect unless you
make the columns narrower than the angled text.



in excel.
 
H

Herb Tyson [MVP]

When I saw your response, Suzanne, I thought I'd awoken in an alternative
universe, one in which Word is quite different from the Word I know... I
went through the steps to verify what I already knew -- no such red diamond
existed. Then, in desperation and confusion, I read the previous response
and discovered you were talking about Excel... not Word. Man, was I
relieved. :p
 
S

Suzanne S. Barnhill

Yeah, well you do have to be following the thread! And of course, although I
didn't mention it earlier, presumably an Excel object could be embedded in
Word in order to accomplish this in a Word document (but only for one page
or less).
 
Top