Can I, and how?

  • Thread starter Thread starter Tcs
  • Start date Start date
T

Tcs

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 force Excel to use a range of 9.0 thru 70, rather than what *IT*
wants to do? How?
Click to expand...
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?
Click to expand...
Double click the x-axis to open format dialog; on Format tab set your font
size to a lower value

Happy New Year
 
Coooool! This is great!

Thanks!!!

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)
Double click the x-axis to open format dialog; on Format tab set your font
size to a lower value

Happy New Year
Click to expand...
 
Back
Top