In the Interval between tick marks text box, type the number of units you want between the tick marks of your chart's x-axis.īoth horizontal and vertical axes can be the Value axis. On the Format tab, in the Current Selection group, from the Chart Elements pull-down list, select (Category) Axis.įrom the Current Selection group, click Format Selection.įrom the Categories list, select Axis Options. NOTE: If your category axis is denoted by words or phrases, the Automatic option will suffice in most cases. If your desired axis is the Value axis, refer to Changing the Interval of the Value Axis below.
![how do i change the series name on a scatter chart excel how do i change the series name on a scatter chart excel](https://cdn.extendoffice.com/images/stories/doc-excel/bubble-chart/doc-bubble-1.png)
With the Category axis, you can change the interval of units between the tick marks. Changing the Interval of the Category Axisīoth horizontal and vertical axes can be the Category axis.
![how do i change the series name on a scatter chart excel how do i change the series name on a scatter chart excel](https://img.pagecloud.com/aXDEoX1q-TMiPU_R-0n8liQvybY=/881x0/filters:no_upscale()/simplexct/images/Fig1-e7a42.jpg)
For basic information on how Excel converts worksheet data into charts, refer to About Charting and Creating a Basic Chart. When setting up your chart, it is important to understand how Excel will display your worksheet data (e.g., what information will be assigned to which axis). Since axes and axis labels are such important parts of an effective chart, Excel provides extensive formatting options. Axis labels (automatically assigned by Excel when you create your chart) connect this visual information with specific data categories, providing the context readers need to make sense of your chart. The field created by these intersecting axes contain visual indicators (e.g., bars, columns, dots) that give readers an intuitive understanding of your chart data. One of them will be a Value axis, which displays numerical values that measure charted categories, and the other will be a Category axis, which displays one or more data series that measured against each other by numerical values. The horizontal line is called the x-axis the vertical line is called the y-axis. In charts, axes are the two lines that frame your data. Click and drag the text box to the desired location.Move the cursor to the border of the text box so it displays a four-headed arrow.(Optional) To reposition your chart title,.In the Chart Title text box, type a name for your chart. The Chart Title text box appears in your chart.
![how do i change the series name on a scatter chart excel how do i change the series name on a scatter chart excel](https://i.stack.imgur.com/s4LMQ.png)
Adding a Chart TitleĬhart titles should provide a concise summary of the information displayed.įrom the Layout command tab, in the Labels group, click Chart Title » select a location for the title. NOTE: This document assumes you have already created your chart.
#How do i change the series name on a scatter chart excel how to#
This document will explain several options on how to add more features to your chart. Learning how to use these charting features in Excel 2007 can make your charts more efficient. This article is based on legacy software.Īdding titles, legends, axes, labels, tables, and gridlines to your chart can give it a helpful visual boost. (Archives) Microsoft Excel 2007: Working with Chart Elements