#16
|
||||
|
||||
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. |
#17
|
|||
|
|||
Quote:
20200901113053.png 11111111111111111111.png |
#18
|
|||
|
|||
Quote:
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 |
#19
|
||||
|
||||
See attached
|
#20
|
|||
|
|||
I want the last look,thanks! 20200902114929.png Thank you very much for your help, this code meets the requirements. Personally, I am thinking, if it is more complete, can I automatically assign different colors to the columns in each image like this picture, and add the marks shown in the red box on the horizontal and vertical coordinates. Thanks again!Best wishes! |
Tags |
histogram |
|
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 |