build a histogram using vba

Copper Contributor

i am trying to build a histogram using excel vba. Instead of using a range of cells in the relevant code i would like to use a variable which takes 1.000 (say) values. How this can be done ?


1 Reply


With your permission, if I can recommend you, insert a file (without sensitive data) and explain your problem in detail. So you can get a solution proposal to your problem much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

It is also helpful to know the operating system, as different approaches may be required depending on the Office version and OS.


In order not to be misunderstood, in the community it is the aim of excel users to give help on their project (from Excel users), or rather, to provide food for thought and not to deliver finished work or finished ideas.



Thank you for your understanding and patience



I know I don't know anything (Socrates)