Related videos

Much to my chagrin, pivot charts are PC swim only. Boo hiss!!! You can see this epic fail in action here. He was in a hurry and asked me to just create screenshots of each of the charts, and he showed those to the client instead. I created a video demonstrating how to take the data spawned from the advanced filters. Have you ever tried to control a compulsion?

But you can see a quick tutorial on how to change those dashes to zeros or check out my more comprehensive post on number formatting on the Search Engine Land site. Click the Chart Output check box, then click OK. Share Pin Email.


  1. How to make a Gantt chart in Excel.
  2. How to Create a Line Chart in Excel 2010.
  3. free movie converter for mac download.
  4. Subscribe to RSS.

She's written tips and tutorials for Microsoft Office applications and other sites. Updated August 08, Select the entire dataset. Go to the All Charts tab and select Histogram. Select the Histogram option, then select OK. Select Categories if you want to display text categories. Select Number of Bins to establish a specific number of bins displayed.

Close the Format Axis pane when you have finished customizing the histogram. Go to the File tab, then select Options. Select Add-ins in the navigation pane. The Analysis ToolPak should be installed. The add-in is not available in Excel for Mac. Go to the Tools menu and click Excel Add-ins.

How do I create a Pivot Chart in Excel 2011 for Mac?

Click Yes to install the add-in if prompted. Once you've installed the add-in, you can create a histogram:. Go to the Data tab and click Data Analysis. Simply change the numbers in the boxes to make the starting and ending point the minimum and maximum, respectively. From this menu, you can change the font style and color, and add shadows or other effects. Data labels show the value associated with the bars in the chart. This information can be useful if the values are close in range. To add data values, right-click on one of the bars in the chart, and click Add Data Labels.

Make a Graph in Excel

This will create a label for each bar in that series. For clustered charts, one of each color will have to be labeled. Click and drag the legend to a new location on the chart, or click on it and press the delete button on your keyboard to remove it completely. The items will appear in reverse order from the spreadsheet.

This change will also affect the order of the data clusters, if that was the chart format chosen.

Excel Gantt chart tutorial + Free Template + Export to PPT

In some versions of Excel, you can also change the data order by selecting one of the bars and editing the formula bar. If the text on an axis is long, pivot it on an angle to occupy less space. Right-click the axis, click Format Axis , click Text Box , and enter an angle. You can also opt to only show some of the axis labels.

Right-click the axis, click Format Axis , then click Scale , and enter a value in the Interval between labels box. A value of 2 will show every other label; 3 will show every third. If you want to create a cleaner, less cluttered chart, hiding some labels is a good option. But the context of the hidden text is still obvious. Update the spreadsheet and the values in the chart will update, too. Right-click a bar, then click Format Data Series … and make adjustments.

The Sample Data

In addition to changing the color, you can also add a gradient or pattern, as well as many other effects. For clustered bar charts, any changes will only affect the bars associated with the same dependant variable of the selected bar.

Download 200+ Excel Shortcuts

Repeat to update all the bars in the chart. To change the background, right-click in a blank area of the chart and click Format Chart Area … or right-click the plot area and click Format Plot Area …. Like the bars, you can change the color, add a gradient or pattern, adjust the color and size of lines, as well as other effects.

A data table displays the spreadsheet data that was used to create the chart beneath the bar chart. This shows the same data as data labels, so use one or the other. To add a data table, click the Chart Layout tab, click Data Table , and choose your option. If the legend key option is chosen, you can remove the legend as demonstrated in the image below. To swap the vertical and horizontal axes, right-click on the chart and click Change Chart Type. If you chose a column chart, chose bar chart instead, and vice versa.

There are other ways to do this, but this is the simplest. Trend lines show the overall trend of your data falling or rising if the numbers are somewhat scattered.


  • Microsoft Excel - Wikipedia.
  • How to Make a Frequency Distribution Graph in Excel for Mac 2011.
  • free sound converter for mac.
  • Footer Resource links.
  • Why Use Combination Charts?.
  • Create embedded chart.
  • Trend lines are only available on column charts. Unlike most of these options, trendlines will accumulate rather than being replaced if you change the chosen type. Error bars show the margin of uncertainty in data.