Problems with vba frequency distribution histogram

p45cal · #1 08-31-2020, 09:22 AM

1. In the attached, the same 3 sheets with the macro adjusted to allow manual input.
2. A further 3 sheets (suffixed with b) with a pivot table & chart solution.

leeqiang · #2 08-31-2020, 08:34 PM

Quote:

Originally Posted by p45cal

1. In the attached, the same 3 sheets with the macro adjusted to allow manual input.
2. A further 3 sheets (suffixed with b) with a pivot table & chart solution.

20200901113053.png

11111111111111111111.png

leeqiang · #3 08-31-2020, 08:56 PM

Quote:

Originally Posted by p45cal

1. In the attached, the same 3 sheets with the macro adjusted to allow manual input.
2. A further 3 sheets (suffixed with b) with a pivot table & chart solution.

Thank you very much for your help, the code is very simple and easy to understand, and the generated data and images are very good. Another small problem is how to display the vertical coordinate of the pivot table as the frequency divided by the group distance

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to draw the histogram?	leeqiang	Excel Programming	1	08-27-2020 05:19 PM
Frequency of Count Ifs	keeble	Excel	4	02-01-2017 10:33 AM
Formula to calculate Frequency	lwls	Excel	1	03-30-2015 05:40 AM
Trying to count frequency	borninscorpio	Excel	4	07-31-2013 12:44 AM
Frequency of a name	bryant03	Excel	1	06-27-2012 10:21 AM