Automated Excel Dashboard Creation

₹1250-2500 INR / hour

Posted 1 minute ago

•

Ends in 6 days

₹1250-2500 INR / hour

I have a single worksheet that already holds all of our raw numbers; what’s missing is a clean, reusable dashboard. I’d like you to take that data and build a set of clear, visually engaging charts—think revenue trendlines, category comparisons, and at-a-glance KPIs—combined in one interactive dashboard within the same file. Because the source data is already structured on one sheet, the task centres on designing the right PivotTables, charts, and slicers (or similar filters) so the information updates automatically whenever I refresh the sheet. The finished workbook should open on a dashboard tab that team members can read immediately without touching the underlying data. Deliverables: • One dashboard tab containing several key charts (bar, line, pie or whichever best tells the story). • All charts linked to the existing data sheet so they update on refresh—no manual copying. • Clear labels, colour-coding, and a brief note explaining how to refresh or extend the dashboard when new rows are added. Once I can open the file, click “Refresh,” and see the latest numbers reflected across every visual, I’ll consider the job complete.

Project ID: 40813150

About the project

4 proposals

Open for bidding

Remote project

Active 4 secs ago

Place your bid

Bid amount Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

It's free to sign up and bid on jobs

4 freelancers are bidding on average ₹1,562 INR/hour for this job

User Avatar
Flag of GERMANY

Your raw numbers already sit on one sheet, so the dashboard can be built straight on top of it and refresh with a single click. I would first turn the data range into an Excel Table, so new rows are picked up automatically. Then I would build PivotTables for the revenue trend, the category comparison and the KPI totals, with PivotCharts and shared slicers (plus a timeline if you have a date column) on one dashboard tab that opens first. The raw data can be hidden or protected. You get the same workbook back with consistent colours, labelled charts and a short note on the dashboard explaining Refresh All and how to add new columns or categories. I have worked with data processing in Python and Excel since 2014, starting with my PhD research in Frankfurt, Germany (30+ publications). Before you award the project, I can send a free sample built on a copy of 20 rows: one PivotChart with a slicer. Which Excel version does your team use (Microsoft 365, 2019 or older), and do you need it to work in Excel Online as well? Wahed

User Avatar
Flag of SERBIA

Hi, I will build a clean, reusable Excel dashboard in the existing workbook, with interactive visuals, KPIs, PivotTables, and filters linked directly to your raw data sheet. I’ll structure the source range as an expandable Excel Table, create the required PivotTables and PivotCharts, and add slicers for intuitive filtering. The dashboard tab will open first and include revenue trends, category comparisons, and clearly labelled KPI cards. I’ll also apply consistent colour-coding and provide concise instructions for refreshing and extending the dashboard with new rows. I’ll test the Refresh workflow to ensure every visual updates without manual copying and verify that the layout remains readable for team members. Thank you

User Avatar
Flag of GERMANY

A dashboard tab that opens first, with revenue trendlines, category comparisons and KPI tiles all reading from your one data sheet, so a single Refresh All updates every visual. I build the charts on formula-driven summaries (or PivotTables where they suit your columns), add slicers for the main filters, and keep colours and labels consistent. The data sheet stays untouched and the dashboard tab is clean for your team to read. Before handover I add new test rows, refresh, and check that every KPI and chart total matches the source. A short note on the sheet explains how to refresh and how to extend the range when rows are added. My Cash-flow dashboard (Excel) sample on my profile shows the style. Which columns does your sheet have (date, category, revenue, region?), and which Excel version do your team members use? Slicers need 2013 or newer. I can send a first draft on a copy of your data. Moritz

内容来自 Freelancer News,版权归原作者所有。

阅读原文 ↗

把喜欢的内容,留在你的新标签页。

打开我的订阅