![]() Otherwise, leave this at "one" and every tick mark displays on the axis, whether it has a label or not.Ĭlick "Close" to close the Format Axis window and apply the changes to your chart. So if you enter "three" into this box, the first, fourth, seventh and tenth - continuing until you run out of labels - display.Ĭlick on the text box next to "Interval between tick marks." Enter the same number as your interval unit if you only want Excel to show a tick on the axis when it displays a label. The first axis label displays, then Excel skips labels until the number of your interval, and continues on in this pattern. Type in the interval that you want to use for the X-axis labels. The Format Axis window appears.Ĭlick on the radio button next to "Specify interval unit," then place your cursor into the small text box next to the button. ![]() Click the "Format Selection" button next to the drop-down arrow to continue. ![]() Now I would like the graph to show the time since the water was added. Click on the "Layout" tab at the top of the Excel window, then click the drop-down arrow on the left side of the ribbon and choose "Horizontal (Category) Axis" from the list of options. How do I format a scatter plot so that the x axis shows time Context: I took soil moisture measurements frequently (30+ times) over a day to see the evaporation rate. When you have more than one data series that you want to plot on the same chart, you can create a combination chart in order to deliver a visual representation of each of the data series.
0 Comments
Leave a Reply. |