Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 08-31-2020, 09:22 AM
p45cal p45cal is offline Problems with vba frequency distribution histogram Windows 10 Problems with vba frequency distribution histogram Office 2019
Expert
 
Join Date: Apr 2014
Posts: 411
p45cal is a jewel in the roughp45cal is a jewel in the roughp45cal is a jewel in the roughp45cal is a jewel in the rough
Default

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.
Attached Files
File Type: xlsm msofficeforums45540plansv4.xlsm (76.6 KB, 2 views)
Reply With Quote
  #17  
Old 08-31-2020, 08:34 PM
leeqiang leeqiang is offline Problems with vba frequency distribution histogram Windows 10 Problems with vba frequency distribution histogram Office 2019
Novice
Problems with vba frequency distribution histogram
 
Join Date: Aug 2020
Posts: 16
leeqiang is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
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
Reply With Quote
  #18  
Old 08-31-2020, 08:56 PM
leeqiang leeqiang is offline Problems with vba frequency distribution histogram Windows 10 Problems with vba frequency distribution histogram Office 2019
Novice
Problems with vba frequency distribution histogram
 
Join Date: Aug 2020
Posts: 16
leeqiang is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
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
Reply With Quote
  #19  
Old 09-01-2020, 03:38 AM
p45cal p45cal is offline Problems with vba frequency distribution histogram Windows 10 Problems with vba frequency distribution histogram Office 2019
Expert
 
Join Date: Apr 2014
Posts: 411
p45cal is a jewel in the roughp45cal is a jewel in the roughp45cal is a jewel in the roughp45cal is a jewel in the rough
Default

See attached
Attached Files
File Type: xlsm msofficeforums45540plansv5.xlsm (77.8 KB, 7 views)
Reply With Quote
  #20  
Old 09-01-2020, 08:54 PM
leeqiang leeqiang is offline Problems with vba frequency distribution histogram Windows 10 Problems with vba frequency distribution histogram Office 2019
Novice
Problems with vba frequency distribution histogram
 
Join Date: Aug 2020
Posts: 16
leeqiang is on a distinguished road
Default

Quote:
Originally Posted by p45cal View Post
See attached



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!
Reply With Quote
Reply

Tags
histogram

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to draw the histogram? leeqiang Excel Programming 1 08-27-2020 05:19 PM
Problems with vba frequency distribution histogram 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
Problems with vba frequency distribution histogram 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 12:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft