![excel graph axis label start at 0 excel graph axis label start at 0](http://www.liangshunet.com/lsfile/ct/2019/11/tt4d8kfm2115504.gif)
![excel graph axis label start at 0 excel graph axis label start at 0](https://peltiertech.com/wp-content/uploads/2019/11/NotInvertedAxisCrosses.png)
To put a prefix in front of all axis numbers, or a suffix after:Įnter the prefix (i. Or select the axis numbering by clicking once then drag the numbering with the mouse or nudge it by clicking the arrow keys: Select the position of the axis numbering in the Axis Titles section on the Titles and Fonts tab of the Format Axes dialog. To move the numbers above/below the X-axis or to the right/left of the Y-axis: Set on the New Graphs tab of the Preferences dialog. To change the default font used for new graphs: Or select an axis by clicking on it, and use the Font settings in the toolbar. Click the Font button in the Numbering or labeling section. Go to the Titles and Fonts tab of the Format Axes dialog. To change the font, size, and color of the numbering for one axis: Column graphs always label the X axis with column titles. Survival graphs always use survival time as the X values. You may or may not see all three choices, depending on how you configured your graph. With Grouped graphs (and graphs of contingency tables), you can have a choice of labeling the X axis with row titles, column titles, or row number. If you entered elapsed times or dates instead of X values, Prism presents a different set of choices for Number format. If you ask for a grid line at X=5, Prism will draw it to correspond with the point in the fifth row, whatever its X value. Prism also uses this coordinate system (row numbers) when positioning additional ticks and grid lines. Keep in mind that Prism uses the row number (first row is 1) rather than the values entered into the X column, to position the data and determine which labels to show. You can ask Prism to plot, say, every fifth row label by changing the major tick interval to 5, starting at 0. If you have many rows, this will be cluttered. Essentially, Prism uses the row number as the X value, so the points will be equally spaced along the X axis, even if the X values are not evenly spaced. When you choose to label the X axis with row titles, the spacing of the points may change. Choose in the Number format drop down in the Regularly spaced ticks part of the Format Axes dialog. If you enter row titles for each row, then you can choose to label the X axis with row titles rather than X values. If the X values are not evenly spaced, then the points won't be equally spaced. Normally, of course, the X axis of an XY graph plots the X values you enter into the X column. What values or labels show on the X axis? Or click on the Format Axis tool in the Prism toolbar. Double-click on an axis to open the Frame and Origin tab of the Format Axes dialog.