How do I set my Excel Chart to not show areas where I have no dat.

A

AmyJ

The lowest data on my chart is a 17... how do I set up the chart so that the
blank areas for 1 through, say, 15 are not shown and the chart starts at 15?
 
J

John Mansfield

Amy,

Double-click on your Y value axis scale. In the format Axis dialog box, go
to the Scale tab. Enter the number 15 in the minimum scale entry box.
 
Top