How do I set my Excel Chart to not show areas where I have no dat.
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. ---- Regards, John Mansfield http://www.pdbook.com "AmyJ" wrote: 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? |
All times are GMT +1. The time now is 05:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com