These numbers represent the values in cell A9 and B9 on the worksheet. The first data point to appear in the scatter chart represents both a y value of 137 (particulate) and an x value of 1.9 (daily rainfall). These data points may be distributed evenly or unevenly across the horizontal axis, depending on the data. The chart displays points at the intersection of an x and y numerical value, combining these values into single data points. Often referred to as an xy chart, a scatter chart never displays categories on the horizontal axis.Ī scatter chart always has two value axes to show one set of numerical data along a horizontal (value) axis and another set of numerical values along a vertical (value) axis. In a scatter chart, the daily rainfall values from column A are displayed as x values on the horizontal (x) axis, and the particulate values from column B are displayed as values on the vertical (y) axis. For example, when you use the following worksheet data to create a scatter chart and a line chart, you can see that the data is distributed differently. Your chart uses text from its source data for these axis labels.The main difference between scatter and line charts is the way they plot data on the horizontal axis. This will open a drop down menu.Ĭhange the text of the labels. Use t to set text properties of the label after it has been created. The y axis of the graph is the vertical line running top to. The x axis of a graph is the horizontal line running side to side. In the labels section click on axis titles. Navigate to the layout tab in microsoft excels toolbar. If you havent yet created the document open excel and click blank workbook then create your graph before continuingstep 2 select the graph. Dont confuse the horizontal axis labelsqtr 1 qtr 2 qtr 3 and qtr 4 as shown below with the legend labels below themeast asia sales 2009 and east asia sales 2010.Ĭlick each cell in the worksheet that contains the label text you want to change. Double click an excel document that contains a graph.

Label the x axis and return the text object used as the label.ĭoing so will cause a group of tabs titled chart tools to appear in excels toolbar with the design layout and format tabs residing within it. You can use a similar approach to add variable values to axis labels or legend entries. Include a variable value in the title text by using the num2str function to convert the value to text.Īdd a title with the value of sinπ2. Proper way to label a graph labeling the x axis.Ĭlick anywhere on the chart you want to add axis labels to. You must also chose a proper scale for the x axis and label it with. Click your graph to select itstep 3 click.Īdd Axis Label To Bar Chart Using Tikz Tex Latex Stack Exchange Step 1 open your excel document. Its to the right of the top right corner of the graph.

Best excel scatter plot labels