Interactive Monthly Sales Excel Dashboard

via Freelancer ·

Budget / Salary$250–750
TypeFreelance project
LocationRemote
Posted1 hour ago
I have a clean data set of monthly sales that needs to come to life inside Excel. The goal is a single, interactive dashboard that instantly tells me three things: how much revenue we generated each month, how many units we moved, and what our profit margins looked like.

I picture a layout where dynamic charts and graphs present the trends at a glance, supported by neatly formatted tables for quick detail checks. Slicers or other interactive filters should let me drill down by product line, region, or any other field you think is useful, all without breaking the flow of the visuals.

What I need from you:
• An Excel workbook containing the fully-built dashboard on a dedicated tab
• All formulas, pivot tables, and named ranges clearly organized so I can tweak or expand them later
• Clean, consistent formatting (colors, fonts, number formats) that matches standard business style
• Brief, inline instructions or comments explaining how to refresh the data and add new months

If you have tricks for making the filters extra intuitive or the charts more engaging, feel free to suggest them—I’m open to improvements as long as the core metrics stay front and center. Once delivered, I’ll test the workbook with fresh data; if everything updates smoothly and the visuals remain intact, we’re set.
visual basic data processing data entry excel excel macros data visualization data analysis data management
Apply on Freelancer →

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