- #ENTER A CUSTOM POINT IN SCATTER CHART EXCEL HOW TO#
- #ENTER A CUSTOM POINT IN SCATTER CHART EXCEL SERIES#
We next change the chart title by simply highlighting the title (Income) and changing it to a more informative title such as Average Income by Age. The legend labeled Income is not particularly useful and so we eliminate it by clicking on the chart and selecting Layout > Labels|Legend> None.
#ENTER A CUSTOM POINT IN SCATTER CHART EXCEL SERIES#
We next describe a series of modifications that we want to make to the chart. To create the chart we highlight the range B3:B13 and select Insert > Charts|Line. The main difference is that you need to select Insert > Charts|Line.Įxample 2 – Create a line chart for the average income of a sample of people in their thirties by age based on the data in Figure 2.
The process for creating a line chart is similar to that of a bar chart. a stacked bar chart instead of a side-by-side bar chart). You can also change the type of chart by clicking on the chart, selecting Design > Type|Change Chart Type and then choosing the chart type that you want (e.g. If instead of a chart of sales by city, you want a chart of sales by brand, you can click on the chart and select Design > Data|Switch Row/Column. the ratio of the length to the width) doesn’t change it is important to hold the Shift key down while dragging the corner. We can then resize the chart, making it a little smaller (or bigger), by clicking on one of the corners of the chart and dragging the corner to change the dimensions. To get the results displayed in Figure 1 we also needed to move the chart within the worksheet by left-clicking on the chart and dragging it to the desired location. Finally, you can add the title of the vertical axis by selecting Layout > Labels|Axis Titles > Primary Vertical Axis Title > Rotated Title. You can add the title of the horizontal axis in a similar manner by selecting Layout > Labels|Axis Titles > Primary Horizontal Axis Title > Title Below Axis and entering the word City. To add a chart title click on the chart, select Layout > Labels|Chart Title and then choose Above Chart and enter the title Marketing Campaign Results. The resulting chart is shown in Figure 1, although initially, the chart does not contain a chart title or axes titles. the data (excluding the totals) including the row and column headings, and select Insert > Charts|Column.
The first step is to enter the data into the worksheet.
#ENTER A CUSTOM POINT IN SCATTER CHART EXCEL HOW TO#
We now demonstrate how to create a bar chart via the following example.Įxample 1 – Create a bar chart for the data in Figure 1. At any time you can click on the chart to get access to these ribbons.