Where Is A Histogram In Excel How To Make A

Before creating your histogram, import or input the data you want to display as a histogram in a new Excel workbook table with separate columns or rows for value and frequency data.

Open the workbook file that contains your data in Microsoft Office for Mac Excel.

Select and highlight the range of data cells in the table.

Dont include the data labels that describe each column or row of data.

Click the Charts tab on the main menu ribbon.

Click the Column button in the Insert Chart group, and then select the Clustered Column option.

You can select and drag the chart to a convenient location on the screen.

Click anywhere on the chart and select and highlight the data cells in the table again.

Enter a title for your histogram in the space provided on the chart.

Select the Axis Labels button in the Labels group on the ribbon.

Click the Vertical Axis Title button and enter a vertical axis title in the space on the chart.

Select Axis Labels followed by Horizontal Axis Title and type a horziontal access title in the space on the chart.

Click on any bar in the histogram to select all bars, and then choose Format Data Point in the context menu.

Change the value in the Gap Width box to 0 to remove all space between the bars in the histogram, and then click the OK button.

Save the workgroup document to preserve your histogram.

Warnings The information in this article applies to Microsoft Office for Mac 2011.

It may differ slightly or significantly for other versions of Microsoft Office.

Where Is A Histogram In Excel How To Make A

References YouTube: How To Make a Histogram in Excel 2011 Microsoft Office: Mac; Chart Types Resources Histograms: Construction, Analysis and Understanding Microsoft Office: Mac; Support Photo Credits JupiterimagesGoodshootGetty Images About the Author Adrian Grahams began writing professionally in 1989 after training as a newspaper reporter.

His work has been published online and in various newspapers, including The Cornish Times and The Sunday Independent.

He holds a Bachelor of Science, postgraduate diplomas in journalism and website design and is studying for an MBA.

Related How to Make Bars Closer Together in Column Graphs in Microsoft Excel for Mac How to Do an Outline in Excel How to Add an Overlay to Excel How to Put Two Sets of Data on One Graph in Excel How Do I Create a Column Chart in Excel Then Move It to a New Page in My Workbook How to Make a Bubble Graph on Microsoft Word Most Popular How to Hide Empty Data in Excel Graphs WordPerfect: How to Graph How to Make All Excel Rows the Same Height How to Redraw a Legend on Excel How to Remove an Embedded Chart in Excel Trending Now 1 How to Make Bars Closer Together in Column Graphs in Microsoft Excel for Mac 2 How to Do an Outline in Excel 3 How to Add an Overlay to Excel 4 How to Put Two Sets of Data on One Graph in Excel Most Popular 1 How Do I Create a Column Chart in Excel Then Move It to a New Page in My Workbook 2 How to Make a Bubble Graph on Microsoft Word 3 How to Hide Empty Data in Excel Graphs 4 WordPerfect: How to Graph 5 How to Make All Excel Rows the Same Height Logo Return to Top About Privacy Notice Your California Privacy Rights Interest Based Ads Terms of Use Our Company Careers Advertise with Us Ad Choices Contact Customer Service Newsroom Contacts Connect Email Newsletter Facebook Twitter Pinterest Google Instagram Subscribe iPad app HoustonChronicle.com Houston Chronicle Archives eEdition Demo Todays eNewspaper Hearst Newspapers Copyright 2020 Hearst Newspapers, LLC.

Where Is A Histogram In Excel For Mac