How to create a chart in the form of Mode?
example: https://bit.ly/3eRaj78
Edit: Attached image to post, since these bit.ly links always break after a bit -- MrProgrammer, forum moderator |
Edit: Attached image to post, since these bit.ly links always break after a bit -- MrProgrammer, forum moderator |
young man -> Listen to me: if you can’t answer a question or don’t know the answer, then walk by and don’t pretend to be smart.Villeroy wrote:Discuss statistics based on screenshots? Are you overburdened by your homework assignment or what?
are you pretending to be smart or clever? here is the file. show me how to do it. Insert > chart.Villeroy wrote:No chart without data. The picture shows an ordinary column chart. Select your data on the sheet, call Insert>Chart... [Finish] and that's it. How much spoon-feeding do you need?
Hi.Hagar Delest wrote:The trick is that you need to carefully evaluate the number of “bins” and the width so that the rendering shows what you want (quite often a bell curve). Have a look at: Number of bins and width, together with the rest of the article of course.
No feature to do that automatically AFAIK.
Please add [Solved] at the beginning of the title in your first post (top of the topic) with the *EDIT button if your issue has been fixed.
I have no idea what you want. The picture of the result is worthless without either the data which was used to make that picture or an explanation from you about your goal. The latter would be better.merdontv wrote:How to create a chart in the form of Mode?
Thank you, Mr.Programmer, you are a kind Person and a true professional. Without ambition, he explained in simple words and showed an example. you are on the right path in life. Thanks!MrProgrammer wrote: If so, create a pivot table and frequency
Whereas you dumped a screenshot andmerdontv wrote:Thank you, Mr.Programmer, you are a kind Person and a true professional. Without ambition, he explained in simple words and showed an example. you are on the right path in life. Thanks!
merdontv wrote:How to create a chart in the form of Mode?
Thank you for the attachment showing your use of FREQUENCY. The FREQUENCY function provides counts of the values in bins. Your attachment shows that you have specified the same bin multiple times. For example, the four cells F14:F17 all have the value -153.75. I don't know what you expect to happen when you do that, and the function description doesn't explain this situation, but the result is that the function chooses one of the duplicate bins to hold the count (four) for -153.75 and puts zeros in the other three. If you don't want extra bins with zeros, don't specify duplicate bin values. There are several ways to remove duplicates (search the forum) but I choose to avoid the problem by using a pivot table instead of the FREQUENCY function. I won't answer questions about removing duplicates in this topic because that is a new subject and would need a new topic.merdontv wrote:last question: how to remove duplicate "0" in frequency.
The same "walk by" advice applies to you. If you don't like Villeroy's answer don't complain. Perhaps someone else will have a different answer for you. But beware of simply ignoring him. He is one of the most valued contributors here and he has my great respect. Just now, he has suggested one way to hide your zero values. I found your initial post to be impossible to understand as well, and ignored it until you provided the attachment. I have edited the subject of this topic to better reflect your question so that others can more easily find it.merdontv wrote:Listen to me: if you can’t answer a question or don’t know the answer, then walk by and don’t pretend to be smart.