How do I name the axes if I am using Excel on a Mac? How do I add titles from one worksheet to a chart sheet within the workbook? By adding the secondary axis, the chart has already changed into a combo chart. So I just need to change conversion to a line. So, as you're watching this, you might guess that changing the chart type is a better Excel already suggests a line, so the only thing I need to do is tick the secondary axis box.
You can add gridlines to your chart to make the data easier to read. Before you edit: Gridlines can be added to line, area, column, bar, scatter, waterfall, histogram, radar, or candlestick charts. On your computer, open a spreadsheet in. Double-click the chart you want to change. At the right, click Customize. Click Gridlines.
Optional: If your chart has horizontal and vertical gridlines, next to 'Apply to,' choose the gridlines you want to change. Make changes to the gridlines. Tips:. To hide gridlines but keep axis labels, use the same color for the gridlines and chart background.
To customize the number of gridlines, in the box under 'Major gridline count' or 'Minor gridline count,' enter a number. The legend describes the data in the chart. You can change the legend’s font and where it shows on the chart. Before you edit: You can add a legend to line, area, column, bar, scatter, pie, waterfall, histogram, or radar charts. On your computer, open a spreadsheet in. Double-click the chart you want to change.
At the right, click Customize. Click Legend. Make changes to the legend.
Add or edit legend headers. On your computer, open a spreadsheet in.
Double-click the chart you want to change. Tip: Make sure the text you want to appear in the legend is the first row or column of your data set. At the right, click Data. Choose an option:. If headers are in rows: Click Use row N as headers. If headers are in columns: Click Switch rows / columns and Use column N as headers.
To edit text in the legend, change your header text. Move or resize a chart.
. Click the chart, then in the Format, click the Chart tab. In the Chart Options section, select the Legend checkbox. In your spreadsheet, click the legend to select it, then do any of the following:. Change the look of the legend text: Click the Style tab at the top of the sidebar, then use the controls to add a background fill, add a border, and more. Resize the legend: Drag the square handles around the legend.
Drag the legend to where you want it. You can position the legend more precisely by selecting it, then pressing the arrow keys on your keyboard. Pressing Shift-arrow moves the legend in larger steps. You can specify whether to show chart gridlines and modify their look. Click the chart.
In the Format, click the Axis tab, then click the button for the axis you want to modify (x or y). Do any of the following:. Set the line type: Click the disclosure triangle next to Gridlines (for the x axis), or Major Gridlines or Minor Gridlines (for the y axis), then click the pop-up menu and choose a line type. Set the line color: In the Major Gridlines section, click the color well or color wheel, then choose a color.
Set the increment for major gridlines: In the Major Gridlines section, click the arrows to the right of the increment field, or type a value in it. Show tick marks for the x or value axis: Click the Tick Marks pop-up menu, then choose a location. You can add reference lines to a chart to mark the average, median, minimum, and maximum values in the chart or another value that you specify. Reference lines make the chart easier to comprehend at a glance and can help you compare the values in the chart to a benchmark value. All chart types can have reference lines, except stacked charts, 2-axis charts, 3D charts, pie charts, and donut charts.
A chart can have up to five reference lines. Click the chart. In the Format, click the Axis tab, then click the Value button near the top of the sidebar. Click the disclosure triangle next to Reference Lines, then choose any of the following types of reference lines from the pop-up menu:.
Average: A line that runs through the mean value of the data. Median: A line that runs through the middle value of the data.
Minimum: A line that runs through the lowest value. Maximum: A line that runs through the highest value. Custom: A line that runs through the value you specify. To show what the reference line represents, select the Show Name and Show Value checkboxes.
To change the settings for a reference line, click the line, then use the controls in the Reference Line tab in the sidebar on the right. To remove a reference line, click the line to select it, then press Delete on your keyboard. Error bars give you a general impression of your data’s accuracy.
They’re represented as small marks whose length indicates the amount of uncertainty associated with a given (the data’s variability). You can add them to 2D line charts, area charts, bar and column charts, stacked bar and column charts, bubble charts, and scatter charts. Click the chart, then in the Format, click the Series tab. Click the disclosure triangle next to Error Bars, then click the pop-up menu and choose a type of error bar. Click the second pop-up menu, choose how error values are calculated (for example, as fixed values or percentages), and change the range of variability you want to display. To change the look of the error bars, click an error bar so you see white dots at either end. All error bars for that data series are selected.
Use the controls in the Bar Style and Shadow sections of the sidebar to make changes. Only the error bars for the selected data series are modified.
To change error bars for another series, click one of its error bars, then make changes. To remove error bars, click the chart, click an error bar, then click the Error Bars pop-up menu in the sidebar and choose None.
Trendlines show the overall direction (or trend) of your data. Trendlines are mostly used for making financial investment decisions and can appear in 2D bar, line, scatter, and bubble charts.
Click the chart, then in the Format, click the Series tab. Click the disclosure triangle next to Trendlines, then click the pop-up menu and choose a type of trendline. Do any of the following:.
Show names for the trendlines: Select the Name checkbox, then type a name in the field. The name you type appears for all trendlines on the chart. To change a name, double-click it on the chart, then type a new one. Show the equation or R-squared value: Select the Show Equation or Show R 2 Value checkbox. To change the look of a trendline, click the line so you see white dots at either end, then use the controls in the Stroke and Shadow sections of the sidebar to make changes: To remove trendlines, click the chart, click a trendline, then click the Trendlines pop-up menu in the sidebar and choose None.