Excel Report & Chart Automation

via Freelancer ·

Budget / Salary₹600–1,500
TypeFreelance project
LocationRemote
Posted1 hour ago
I have a workbook that should generate management-ready reports and visual dashboards automatically instead of relying on manual copying, filtering, and chart updates. The workflow I have in mind is simple for the end user: drop raw data into a sheet or connect to an external source, press a single button, and watch the entire report pack refresh—tables updated, charts rebuilt, and everything formatted consistently for printing or PDF export.

To succeed here, the solution will need to cover:

• Building Excel dashboards and charts that stay linked to the underlying data
• Automating report creation with formulas, VBA macros, or Power Query—whatever is most reliable and maintainable
• Handling large data files, including any cleanup, deduplication, or re-structuring required before the analysis layer runs

Deliverables I expect:
1. A fully automated routine (macro, query, or both) that imports/refreshes data, performs necessary transformations, and updates all report sheets and charts.
2. At least one consolidated “Summary” sheet with dynamic tables and visualisations ready for management review.
3. Well-commented code or a short how-to note so I can adapt the solution as new data fields appear.

When you reply, show relevant experience achieving similar Excel automation—especially examples where dashboards or periodic reports now regenerate with a single click. No lengthy proposals needed; a concise summary of past wins in this exact space will help me gauge fit quickly.
visual basic data processing excel visual basic for apps excel vba excel macros data visualization data analysis
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.