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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top