I'm looking to make a histogram,,,

febausa

New Member
Joined
Feb 4, 2014
Messages
32
For helping me , I do not have much practice with excel yet, I'm looking to make a histogram with the following information: input data (column sum), and bin (column with range value)

SUM BIN
272100-109
172110-119
218120-129
210130-139
0140-149
189150-159
115160-169
171170-179
235180-189
0190-199
195200-209
293210-219
177220-229
279230-239
0240-249
95250-259
194260-269
101270-279
166280-289
0
164
158
224
151
0
148
207
268
229
0
130
155
103
119
0
107
133
191
225
0
188
133
187
190
0
239
145
190
175

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Select the range containing you data and > Insert tab > Column (Under Charts) > Select the one you want.

You can make some changes to the default and make it look however way you want.
 
Upvote 0

Forum statistics

Threads
1,214,812
Messages
6,121,702
Members
449,048
Latest member
81jamesacct

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top