Тёмный

Create Histogram in MS Excel 

Excel Insights
Подписаться 7 тыс.
Просмотров 586
50% 1

This video shows how to create a histogram in Excel. Histograms are used to graph data in buckets of numbers to find how distributed a certain data is based on intervals. Excel can automatically do this using the Insert Histogram tool in MS Excel.

Опубликовано:

 

12 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 5   
@chuksrichard3598
@chuksrichard3598 Год назад
Thank you for this wonderful video. I’ve been searching for what you just explained here.
@ExcelInsights
@ExcelInsights Год назад
Glad it helped!
@waleedibrahim4558
@waleedibrahim4558 Год назад
Thank you for your informative videos. I have a particular case in excel in which I couldn’t find any solution to it and I hope you can help me with it. If I have various numbers in column B, and I need these numbers to be (increased/decreased): • By 0.5 either to make it 20.5 or 19.5 • Or by 1 to make it either 21 or 19 • Or 2 to make it 22 or 18 …etc. • The change should be based on two conditions, a selected text from a drop-down list in the next cell in column C in addition to a number I type in the cell next to them in column D, for example: • The first case scenario is: When I type the number 20 in cell B2 and then I choose the text “increase” from a drop-down list in cell C2 and then I type 0.5 in the cell D2, I want this “increase” to be reflected on B2 and make it 20.5 • The second case scenario: When I type the number 15 in cell B3 and then I choose the text “decrease” from a drop-down list in cell C3 and then I type any number like 1, 2 or 3 in the cell D3, I want this “decrease” to be reflected on B3 and make it 14, 13 0r 12 • The third case scenario: When I type number 10 in cell B4 and then I don’t choose any text from a drop-down list in cell C4 and leave it blank with cell D4, I don’t want any change to be reflected on B4 and leave it 10 as it is. I hope you can find time to answer this very soon. Thanks again.
@ExcelInsights
@ExcelInsights Год назад
Hi, if the numbers in column B are hard coded and you want them (the same cells of column B) to increase, that requires a macro to be done. Otherwise, if macros are out of the discussion, use another column that will perform the increase or decrease based on your conditions. Since you have multiple scenarios, use AND statements combined with nested IFs. Using AND or OR: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-wmVhuBQJOVo.html
@waleedibrahim4558
@waleedibrahim4558 Год назад
@@ExcelInsights Thank you very much for your reply.
Далее
Excel Histogram with Normal Distribution Curve
7:16
Просмотров 194 тыс.
iPhone 16 для НИЩЕБРОДОВ!
00:51
Просмотров 1,9 млн
Bar chart with differences in Excel
13:49
Просмотров 145 тыс.
How to Make a Gantt Chart in Excel
12:54
Просмотров 3,7 млн