Automated Travel Km/h Excel Spreadsheet

I need an Excel spreadsheet to automatically calculate business and personal km/h for my car, and determine the percentage of work use versus personal use.

Requirements:
- Input data: Daily, weekly, or monthly travel distances (flexible)
- Data entry: Manual or automated (flexible)
- Outputs: Total distances for business and personal use, percentages of business and personal use, and visual graphs/charts

Ideal skills and experience:
- Proficiency in Microsoft Excel
- Experience with creating automated calculations and data visualizations
- Ability to design user-friendly spreadsheets

Looking for a clean, efficient, and easy-to-use solution. Please provide samples of similar work.