Excel Automation and Visualization Expert

I'm looking for an Excel expert to assist with two main tasks:

1. Automate tasks with macros to streamline my existing spreadsheet.
2. Create visual data representations, specifically bar charts, to enhance data understanding.

The ideal candidate should have:
- Proficiency in Excel, especially with macros.
- Experience in creating visual data representations, particularly bar charts.
- Strong problem-solving skills and attention to detail.

Please provide examples of similar work done. Looking forward to your bids!