Edit the axis of Excel chart
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
Y-axis
What if I wanted my y-axis labels to be in hundreds, and for the numbers to be in "$" and have an extra decimal place on the end?
To first make my labels in hundreds, click on the y-axis values, then right-click and select "Format Axis", then in "Display units" select "Hundreds".
Next, to make the labels in "$" and have one decimal place, I'd navigate to the "Number" section of the "Format Axis" pane. I'd then select the "Currency" category. After that, I'd specify that I only want 1 decimal place.
X-axis
On my x-axis, let's say that we only want to display every-other week value and that I wanted to add tick marks at each value.
To start, I can click on the x-axis values, then scroll down to the "Labels" section of the "Format Axis" pane and code the value 2 into the "Specify interval unit" field.
Next, to add tick marks go to the "Tick Marks" section of the "Format Axis" pane and select the "Outside" value for both "Major type" and "Minor type".
