Create charts both pie and bar from Master table into a template in specified location

[nolans18]

Hi Everyone,

First of all let me tell you this forum is really very informative and helpful. I must admit the amount of knowledge shared on this platform is just tremendous and keep up the good work guys! You all rock

Coming to my query, I have this huge report which we usually churn out to the clients every month. Unfortunately, due to lack of expertise the whole process is done manually at the moment. It takes a lot of time and effort to create each chart from the raw data collected over the previous month. Therefore, I would really appreciate if someone could please look into the attested attachments below and please let me know if there's a solution to automate the process? As in, if it's possible to just click on the button 'Create Charts' which would then create the charts at the specified locations in the sheets (please refer to the charts already manually created in Demographics and Feedback sheets)?

If you could look at the Master.xlsx file, it contains the raw data (both for demograhics and feedback). Basically, the raw data from the demographics table goes into the "Demographics" sheet on the Report_Template.xlsx file. Similarly, the raw data from Feedback table goes into the "Feedback" sheet on the same file.

I have little to no knowledge on Macros. And this task is such a huge thing for me. I'd like to learn the macros from scratch but for now I need help urgently!!!

Any help would be highly appreciated!

Thanks again

[nolans18]

Can someone please help??? I need this quite urgently!!

[nolans18]

Anyone out there who can help??

[nolans18]

Ok! I have started working on the issue myself. I have automated the charts using macros. Please have a look at the attested excel workbooks.

Basically, the user fetches the raw data from a master workbook(Master.xlsx) by clicking on "Get Charts Data" and then uses that data to create several charts on worksheets such as Demographics and Feedback (Report_Template.xlsm) by simply pressing the buttons "Create Demographics Chart" and "Create Feedback Charts".

But there's a minor problem, the charts are all jumbled and do not show up where they are supposed to be. For example, please have a look at the charts on 'Demographics' sheet, the chart for 'Gender' is not showing up on the specified range (Range("L6").Select) instead it shows at (Range("B76".Select) under "Region/Location".

Can someone please help me with sorting this out for me???

Thanks