software

I have a chart that's *almost* exactly what I want. However...

1.) value range displayed

My values range from 9.5 up to 68 inches. Excel insists on setting
the chart to 0 (zero) thru 80. (Currently the zero is technically
valid I guess, as I haven't filled in all the data. There *are* some
zero values...which shouldn't be zero.)

Can I force Excel to use a range of 9.0 thru 70, rather than what *IT*
wants to do? How?

2.) series names displayed

On the screen, my eleven (11) 'X' axis labels are displayed normally
(horizontilly). When I print my graph however, Excel insists on using
such a large size of font, that it must print them on an angle. And
this in turn raises the bottom of the graph, further quot;squishingquot; it
vertically.

Can I force Excel to reduce the size of the label font so they'll all
print horizontally, and thus quot;UNsquishquot; my graph? How?

I appreciate the help. Thanks in advance,

Tom

Oh yeah, I forgot. I'm using Excel 2k. Sorry 'bout that.

Thanks

gt;Can I force Excel to use a range of 9.0 thru 70, rather than what *IT*
gt; wants to do? How?
Double click the x-axis to open format dialog; on Scale tab set your upper
and lower values (DO NOT put X in the quot;automaticquot; boxes)
gt;Can I force Excel to reduce the size of the label font so they'll all
gt; print horizontally, and thus quot;UNsquishquot; my graph? How?
Double click the x-axis to open format dialog; on Format tab set your font
size to a lower value

Happy New Year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Tcsquot; gt; wrote in message
...
gt;I have a chart that's *almost* exactly what I want. However...
gt;
gt; 1.) value range displayed
gt;
gt; My values range from 9.5 up to 68 inches. Excel insists on setting
gt; the chart to 0 (zero) thru 80. (Currently the zero is technically
gt; valid I guess, as I haven't filled in all the data. There *are* some
gt; zero values...which shouldn't be zero.)
gt;
gt; Can I force Excel to use a range of 9.0 thru 70, rather than what *IT*
gt; wants to do? How?
gt;
gt; 2.) series names displayed
gt;
gt; On the screen, my eleven (11) 'X' axis labels are displayed normally
gt; (horizontilly). When I print my graph however, Excel insists on using
gt; such a large size of font, that it must print them on an angle. And
gt; this in turn raises the bottom of the graph, further quot;squishingquot; it
gt; vertically.
gt;
gt; Can I force Excel to reduce the size of the label font so they'll all
gt; print horizontally, and thus quot;UNsquishquot; my graph? How?
gt;
gt; I appreciate the help. Thanks in advance,
gt;
gt; Tom
Coooool! This is great!

Thanks!!!

On Sat, 31 Dec 2005 15:29:06 -0400, quot;Bernard Liengmequot;
gt; wrote:

gt;gt;Can I force Excel to use a range of 9.0 thru 70, rather than what *IT*
gt;gt; wants to do? How?
gt;Double click the x-axis to open format dialog; on Scale tab set your upper
gt;and lower values (DO NOT put X in the quot;automaticquot; boxes)
gt;gt;Can I force Excel to reduce the size of the label font so they'll all
gt;gt; print horizontally, and thus quot;UNsquishquot; my graph? How?
gt;Double click the x-axis to open format dialog; on Format tab set your font
gt;size to a lower value
gt;
gt;Happy New Year