Question: Create a histogram for recent sales. Click the Sales Forecast sheet tab and select cell G 1 3 . Create a bin range of 1
Create a histogram for recent sales.
Click the Sales Forecast sheet tab and select cell G
Create a bin range of values starting at with intervals of ending at in cell G
Use the Analysis ToolPak to create a histogram for cells E:E Do not check the Labels box and select the bin range in your worksheet.
Select cell H for the Output Range and include a chart.
Position and size the chart from cell K to cell V
Edit the horizontal axis title to display Selling Price and edit the vertical axis title to Number of Sales.
Edit the chart title to display Sales by Price Group.
Select and delete the legend.
Clear the contents in cells G:GFigure
I dont know how to make a bin range I just need a step by step tutorial for some of these.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
