Problems with vba frequency distribution histogram

p45cal · #11 08-29-2020, 06:10 AM

Quote:

Originally Posted by leeqiang

The reason for using vba instead of the perspective chart is that when I change the two manually entered values mentioned above, the code can automatically generate new data and charts. Thank you!

I was asking if the 3 for the group interval was always 3 or if it needed to be calculated from the source data or from perhaps a cell value in the sheet. As it is I've used a hard-coded 3.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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