| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hide column but show chart | Charts and Charting in Excel | |||
| Text box in Excel Chart | Charts and Charting in Excel | |||
| On a scatter chart show two point have same value | Charts and Charting in Excel | |||
| Excel 97 chart opened in Excel 2003 - Source Data problem | Charts and Charting in Excel | |||
| Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel | |||
Linear Mode
