May 21 2021 10:09 PM
I have a data range with data points for successive date/time values. The data are number of steps in a Fitbit challenge. I wanted to chart the difference between my steps and those of one of the other competitors. I made a new column called "Anne-Don" with a formula subtracting the steps value for Don from the steps value for Anne in each row. I have pasted a screenshot of the chart below. As you can see, over time the result of the formula is sometimes positive (Anne is ahead of Don) or negative (Don is ahead of Anne). The problem is that the data series line goes below the labels for the X axis. I want the labels to be BELOW the lowest negative value on the graph. How can I accomplish this? I have tried using the "Format Axis > Alignment > Vertical alignment" and changing it from "Middle Centered" to "Bottom Centered" but that has no effect.
May 21 2021 10:59 PM - edited May 21 2021 11:01 PM
Solution@Snoopdon In the Format Axis dialogue, under Labels, set the label position to Low and the axis labels will show at the bottom of the charting area.
May 21 2021 10:59 PM - edited May 21 2021 11:01 PM
Solution@Snoopdon In the Format Axis dialogue, under Labels, set the label position to Low and the axis labels will show at the bottom of the charting area.