stanhilliard
10-24-2021, 06:36 PM
I have two Excel 2016 scatter plots that seem to be identical except for their data source. One has a vertical axis with tick marks, the other, I can't make tick marks show.
Here is what I do:
1 Right click [format axis]
2 Select the [text options] icon.
3 Click [Tick Marks]
4 Major type, select "outside".
Nothing happens.
One difference I noticed between the two charts is that when I select the vertical axis of the chart with the tick marks, the line that goes around the number does not extend into the plot area. The corresponding line of the "bad" chart is well into the plot area.
The horizontal axes of neither chart will display tick marks. The selection rectangle around the horizontal axes runs along zero of the vertical, but the axis is across the middle of the plot. Zero is in the middle of the vertical axis, which contains both positive and negative numbers.
Here is what I do:
1 Right click [format axis]
2 Select the [text options] icon.
3 Click [Tick Marks]
4 Major type, select "outside".
Nothing happens.
One difference I noticed between the two charts is that when I select the vertical axis of the chart with the tick marks, the line that goes around the number does not extend into the plot area. The corresponding line of the "bad" chart is well into the plot area.
The horizontal axes of neither chart will display tick marks. The selection rectangle around the horizontal axes runs along zero of the vertical, but the axis is across the middle of the plot. Zero is in the middle of the vertical axis, which contains both positive and negative numbers.