Excel Workout 26 - Histogram Chart!

IlgarZarbaliyev · June 22, 2023, 8:44pm

Welcome to Excel Workout #26!
Difficulty Level:

This week’s Challenge is designed to test your knowledge on Histogram Chart.

HISTOGRAM Chart
A histogram chart in Excel is a graphical representation of data that displays the distribution of a continuous variable. It is commonly used to analyze and visualize the frequency distribution of data points within specified ranges or bins.

Task

Create a histogram illustrating the frequency distribution. Include data labels on the graph. Establish a bin width of 1000, where the initial bin encompasses salaries up to 3 500 and the final bin encompasses salaries exceeding 10 000.

Submission
Reply to this post with your formula code and solution file. Please be sure to blur or hide your formula code.

Period
This workout will be released on Thursday June 22, 2023 , and the author’s solution will be posted on Thursday June 29, 2023.

Challenge 26.xlsx (8.4 MB)

Good luck,
Ilgar Zarbaliyev

Keith · June 22, 2023, 10:47pm

Hi @IlgarZarbaliyev,

Here is my solution to this workout. This is something that I have never used.

File attached:

Summary

Excel Workout Challenge #26 Keith.xlsx (8.4 MB)

thanks
Keith

ToyinTaiwo · June 24, 2023, 8:17pm

Hello @IlgarZarbaliyev,
Here is my solution to the workout:

Summary

This text will be hiddenThis text will be blurred

Challenge 26.xlsx (8.4 MB)

Thank you.

anonymous211 · June 24, 2023, 8:52pm

Challenge26-Rosi
Challenge 26 Rosi.xlsx (8.4 MB)

mbraun · June 26, 2023, 6:45pm

IlgarZarbaliyev · June 29, 2023, 7:49am

Thank you for participating in the Excel Challenge related to Histogram Chart!
I hope you found this challenge to be a fun and engaging way to improve your Excel skills and learn more about how to work with Histogram Chart! in Excel.

Here is my solution to Workout #26!

Solution
Challenge 26 with Solution.xlsx (8.4 MB)

Once again, thank you for participating in this Excel Challenge, and I look forward to seeing you in future challenges and learning opportunities!

ToyinTaiwo · June 30, 2023, 6:04pm

Hello @IlgarZarbaliyev,

Thank you for providing the solution for the workout. I noticed however, that the dataset you provided for the workout is different from the dataset you used for your solution. The values of the Salary, € are different, so my chart is different from your chart solution.
Could you kindly confirm this?
Thank you.

Regards,
Toyin

IlgarZarbaliyev · June 30, 2023, 6:32pm

Thank you for your message, @ToyinTaiwo
You are right.
The key to solving this example was the path followed by the participants.
Everyone has followed the right path.
Thank you for that.

abbi · July 9, 2023, 5:45am

Challenge 26 (3).xlsx (8.4 MB)

type or paste code here

Sujan_Chhetri · July 15, 2023, 2:56pm

@IlgarZarbaliyev - Please find my submission here.

To insert a histogram chart in your worksheet follow the below steps:

Select your data → Go to Insert tab → Insert Statistic Chart (icon look like histogram) → Histogram → your histogram chart is ready

But this chart doesn’t shows us the desired output that we want. To modify the chart please follow these steps:
right-click on the chart, select “Format Chart Area,” and a window pane will appear on the right side. From the dropdown menu labeled “Chart Options,” choose “Horizontal Axis.”