We have added the titles ‘Temperature’ to X-axis and ‘Sales’ to Y-axis. Let’s add titles to the axes.Ĭlick the ‘+’ floating button, expand ‘Axis Titles’ and check the ‘Primary Horizontal’ and ‘Primary Vertical’ boxes to add titles to both axes. You can add or remove specific elements on the chart (such as Axes, Axis Titles, Data Labels, Error Bars, Gridlines, Legend, Trendline) using the ‘+’ sign floating button on the top right corner of the chart or from the ‘Design’ tab. Let’s set it to ‘100’.Īs you can see the gap is reduced and the scatter looks better now. The WIndow will automatically change to the chosen axis and shows its options.Ĭhange the minimum value of the ‘Bounds’ of the vertical axis. And to reduce the gap on the vertical axis, just click on the axis directly. To reduce the gap, change the ‘Bounds’ value. Here, you can format your axis using various options. To do that right-click on the horizontal axis and click ‘Format Axis’.Ī pane will open to the right side of the Excel. You can change that in the ‘Format axis’ pane. Formatting Axis on Scatter ChartĪs you can see there’s a gap of the first point on the left of both axes. We are choosing basic ‘Scatter chart’ for our data. You can select whatever chart type you prefer (Scatter, Scatter with Smooth Lines and Markers, Scatter with Smooth Lines, Scatter with Straight Lines and Markers, Scatter with Straight Lines, Bubble, or 3-D Bubble). Select your chart type from the drop-down options. Next, go to the ‘Insert’ tab and click on the ‘Scatter’ icon from the ‘Charts’ group on the Ribbon. Here are their sales figures for the last 13 days.įirst, select the two columns with data as shown in above picture.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |