How to label bar graph in excel mac

Use your own discretion when experimenting with these features. Alignment will change the alignment of the labels and will also allow you to change the text direction horizontal, rotated, stacked. As with the horizontal axis there is a dialogue box for modifying the vertical axis. To get to it, double click on the vertical axis and the Format Axis dialogue box will appear.

Remember that the axis is overlaid on the chart area, so make sure you are actually on the axis when you click. You can tell when the axis is selected because light blue dots will appear on the corners. Alternatively, you can reach this dialogue box by going to the Format tab or the Layout tab under the Charts toolbar and selecting Vertical Value Axis from the dropdown menu found at the top of the Current Selection group far left of the Ribbon.

Then select Format Selection. One of the single most important things to know about graphs is how to alter the size of the vertical axis. Such a simple change can greatly alter the appearance of data and potentially the interpretation. The Minimum , Maximum , Major unit , and Minor unit will always be defaulted to Auto , however, you can change the values in the text boxes thereby altering the size of the vertical axis. Here we changed the Minimum from 0 to and the Major unit to which increased the number of gridlines.

Be sure to note that the Major unit can never be smaller than the Minor unit.

Create a chart in Excel for Mac - Excel for Mac

I could alter the axis to focus in on those three. The apparent pattern changes when we zoom in. 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 disclosure triangle next to Reference Lines, then choose any of the following types of reference lines from the pop-up menu:.

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. When you drag the slider on an interactive chart to view different data sets, its reference lines move. 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 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. 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.

Excel Bar Chart Labeled by Year

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 disclosure triangle next to Trendlines, then click the pop-up menu and choose a type of trendline.

Show names for the trendlines: Select the Name checkbox, then type a name in the field. Be sure to include the column and row headers, which will become the labels in the bar chart. If you want different labels, type them in the appropriate header cells. You'll see many options when you select this button, such as 2-D columns and 3-D columns, as well as 2-D and 3-D bars.

For these purposes, we're selecting 2-D columns.

Update a chart title

The chart will appear. You'll also see horizontal bars giving the names of your headers at the bottom of your graph. Next, give your chart a name. Click on the Chart Title section at the top of the graph and the section becomes editable.

Decide where to place the bar chart. It can be placed on a separate sheet or it can be embedded in the spreadsheet.

Customizing Excel charts: add chart title, axes, legend, data labels and more

Then save it. If you want to delete the chart and start all over again, place your cursor on the edge of the chart you'll get a pop-up that says "chart area" and press your Delete key. Include the column and row headers, which will become the labels in the bar chart.

Click the Chart Wizard toolbar button, or choose Chart from the Insert menu. Make sure that Column is selected under Chart type it's the default setting.