Unable to add Data Analysis Tab in Excel 2011 Mac version. Agptek high speed 4 ports usb 2.0 hub for windows vista windows xp 2000 98 and mac os 9.2. Can you please let me know how to add it or suggest any other alternative that is simple and contains all the features. Formatting chart elements in Excel 2011 for Mac You have your choice of using the formatting tools on the three Ribbon tabs, or you can display a dialog by clicking the Format Selection button. The formatting options work the same in charts as for other objects.

Use Values from Cells (Excel 2013 and later) After years and years of listening to its users begging, Microsoft finally added an improved labeling option to Excel 2013. First, add labels to your series, then press Ctrl+1 (numeral one) to open the Format Data Labels task pane. I’ve shown the task pane below floating next to the chart, but it’s usually docked off to the right edge of the Excel window. Click on the new checkbox for Values From Cells, and a small dialog pops up that allows you to select a range containing your custom data labels. Select your data label range. Then uncheck the Y Value option. I also uncheck the Show Leader Lines option, which is another enhancement added in Excel 2013.

These are quick and dirty, because sometimes that’s all that you need. Also, writing your own code allows you to streamline your workflow according to your specific requirements. Add Data Labels from Range Selected by User This routine first makes sure a chart is selected, then it determines which series is to be labeled. It asks the user to select a range using an InputBox, and if the user doesn’t cancel it adds a label to the series point by point, linking the label to the appropriate cell. Bob – Actually, in some cases, Excel 2013’s Value from Cells is better.

The default Starting At value that Excel offers is the first OrderID: 10248. However you can create a neater or different grouping by setting your own Starting At value. To start at 10240, type this value into the Starting At box - you can set the starting point wherever you like even if that value doesn't exist in your data. Here we're setting up the parameters for grouping the data - it will be grouped by OrderID into groups of ten consecutively numbered orders. Here we've set the Starting At value, we've left the Ending At value for Excel to manage and we've left the By value at 10 as this works for our data - you can make groups larger or smaller by changing this value - to, say 5, 20, 50 or 100 and then click Ok.

Take this opportunity to format the labels with the standard formatting tools. You can change font size, color, alignment, and more.

So if you have a large chart, you are in for a lot of clicks and manic mouse maneuvering. • That brings us to Rob Bovey’s. This free tool can automate the whole custom chart labeling for you. • If you want more formatting options, consider adding text boxes and point them to cells instead.

RDBMail puts emailing of Excel sheets, data, and workbooks where you want it and when you want it. It also allows significant customizing of what you send. Very easy to add and edit menu items with this technique Briefly! Power Utility Pak is a useful collection of add-ins that brings significant new functionality to Excel 2011 for the Mac. When PUP is installed, you can do things with Excel that you never thought were possible. Regardless of your experience level.

I wasted a half hour today trying to figure out how to add labels to the X axis. I finally fired up my ancient Windows laptop, added labels with Excel 2002, and then re-opened the spreadsheet on my Mac.

Your pivot table should now appear as follows: In the PivotTable Builder window, choose the fields to add to the report. In this example, we've selected the checkboxes next to the Order ID and Quantity fields. Next under the Values box, click on the 'Sum of Order ID' and drag it to the Row Labels box.

If the labels are entered in the row above the chart data, Excel will recognize them as x-axis labels. The graphic below shows an example of the setup.