Format: More fine-tuning using the selection indicator and chooser, chart element styles, text styles, arrangement, and size tools. Selecting chart elements in Excel 2011 for Mac. To select a chart element, you can either click the element or click the Current Selection pop-up menu found within the Chart Layout tab of the Ribbon.

One of the things that I searched for and had a hard time finding in the Mac version of Excel was how to add the Developer tab to the Ribbon. The Developer tab is a handy way to launch the Visual Basic Editor, launch the Macro dialog box, quickly start recording a macro and access many of the other developer tools available.

To add the Developer tab, select Excel from the menu. It is between the Apple logo and File in the upper left hand corner of the menu. From the drop down menu select Preferences. In the Sharing and Privacy section, select Ribbon. In the middle of the Ribbon dialog box you will see a box listing Tab or Group title. Scroll through this list and find Developer. Check the box and click OK.

You know have access to the Developer tab on the Ribbon. Hopefully this will help someone from countless, fruitless Internet searches that I had to do to discover this information.

Download Add-in Guides and Examples TreePlan, SensIt, and SimVoi For Mac Excel 2011-2016 and Windows Excel 2010-2013-2016 To evaluate our add-ins, please download and examine the PDF Guide file and the XLSX Example file. To download a PDF or XLSX file, click a link shown below. TreePlan decision tree add-in • • SensIt sensitivity analysis and tornado chart add-in • • SimVoi Monte Carlo simulation and value-of-information add-in • • To buy a license with a risk-free 30-day money-back guarantee, browse to the product page for TreePlan, SensIt, SimVoi, or ToolKits. You will be able to download the software ZIP file several minutes after you complete the purchase. Download Decision Analysis Files Except where noted below, the following PDF files are selected chapters from an unpublished manuscript, Decision Analysis Using Microsoft Excel, by Michael R. Click a link for information related to TreePlan, SensIt, and SimVoi. TreePlan and Decision Trees • • • • • • • • • SensIt and Sensitivity Analysis • • SimVoi and Monte Carlo Simulation • • • • PDF of paper from 1982 describing the method SimVoi uses for value of information • Presentation at INFORMS conference, Austin, 2010 Institute for Operations Research and the Management Sciences “Value of Information in Spreadsheet Monte Carlo Simulation Models” Installation (and how to uninstall) • Download Better Histogram Add-in For Mac Excel 2011-2016 and Windows Excel 2010-2013-2016 A histogram in Excel is usually a Column chart type.

The labels of a Column chart are aligned under the center of each vertical bar, and there is no Excel feature for changing that alignment. For continuous-valued data, a better histogram has a horizontal axis with numerical labels aligned under the tick marks between the bars as shown below. To download the XLAM add-in file for automatically creating a Better Histogram from data on an Excel worksheet, click For detailed installation instructions, download the How-To-Install-Addin PDF file.

Before you use the Better Histogram add-in, please use Excel’s MIN and MAX worksheet functions to determine the minimum and maximum values of your data values so that you can decide on “nice” intervals for your histogram. With the XLAM file open or installed, to use the Better Histogram add-in, first select the Excel worksheet containing your data.

To show the Better Histogram dialog box: • In Windows Excel 2010 & 2013 & 2016, choose Add-Ins ribbon > (Menu Commands section) Better Histogram, or press the shortcut key Control+Shift+B. • In Mac Excel 2011, choose Tools Better Histogram, or press the shortcut key Option+Command+B. • In Mac Excel 2016, press the shortcut key Option+Command+B. Inputs for the Better Histogram dialog box: • The data range must be a range of cells containing only numbers, i.e., no text. • The start value must be a number less than or equal to the minimum value of the data range.

• The step value must be greater than zero. • The stop value must be greater than or equal to the maximum value of the data range. • The start, step, and stop values must be chosen so that there are at least two intervals. When you click OK, the frequency distribution and Better Histogram are created on a new worksheet. Free program to check for plagiarism. The add-in automates the original manual method for creating a Better Histogram, described in detail in the paper Download Data Analysis Files • PDF files of data analysis papers • Presentation at Decision Sciences Institute conference, San Diego, 2010 “Better Exponential Curve Fitting Using Excel®” PDF file of PowerPoint slides XLSX file Excel workbook • Excel workbooks of data analysis examples • Four editions of Data Analysis Using Microsoft Excel, by Michael R. Middleton, Duxbury Press Excel 5 (1995), Excel 7 (1997), Excel 97 (2000), Excel XP (2004) Excel workbook.