Updated June 12, 2023
PART- 17 – VBA Charts Excel Essentials
Transcript for Video – VBA Charts Excel
Video on VBA Charts Excel –
Hello friends welcome back having learn some basic fundamentals VBA’s and Macros let us now move forward and learn how we can go about creating charts in excel using Micros and VBA’s so data at hand here is something Google valuation so don’t worry about the data per say were it is coming from let’s focus on modalities associated with creating this charts so I have taken some dummy data and what we have here is on the left hand column these are the valuation mythologies and let’s assume that this no. on the right hand so de the Dollar values and this is the faire value per share so this is the that we have as off now so lets try and create a chart using Macros so as we have seen in another set of exercise the approach will remain similar if you want to automat this thing the first that we do is record Macro using the activities that we want to perform and we extract the code from there and part 2 is we logically connect by manipulating the code so approach has been the 1st step would be to kind of record a Macro and extract the code so lets do that for the time being and for this I’ll go to the Developer Tab I’ll click on record Macros and this is Macro 1 so let me write this as chart sample ok so that’s what kind of do chart sample and let me have a shortcut as well let say Q is my shortcut and I’ll press Ok so whatever I will do now will get recorded here so let me do that.