Can I, and how?
 

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 "squishing" it
vertically.

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

I appreciate the help. Thanks in advance,

Tom

Can I, and how?
 

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

Thanks

Can I, and how?
 

Can I force Excel to use a range of 9.0 thru 70, rather than what *IT*
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 "automatic" boxes)
Can I force Excel to reduce the size of the label font so they'll all
print horizontally, and thus "UNsquish" 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

"Tcs" wrote in message
...
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 "squishing" it
vertically.

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

I appreciate the help. Thanks in advance,

Tom

Can I, and how?
 

Coooool! This is great!

Thanks!!!

On Sat, 31 Dec 2005 15:29:06 -0400, "Bernard Liengme"
wrote:

Can I force Excel to use a range of 9.0 thru 70, rather than what *IT*
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 "automatic" boxes)
Can I force Excel to reduce the size of the label font so they'll all
print horizontally, and thus "UNsquish" 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