Your 'Go To' for Custom Excel Solutions
chart-square

Case Study – Automated Excel Charting

Excel charts allow business to create visualisations of data sets to aid in the understanding of the data collected. Excel provides a range of automated functions for working with your stored data. Our Excel Experts can help you to make use of these, customise them for your business requirements and build custom macros to allow automatic updates of your charts when the data itself is edited. 

Problem

The Problem

This client provides online survey services and was spending countless hours converting survey responses into meaningful and useful charts for their clients.

Solution

The Solution

The solution was to create an application to automate this time consuming task of Excel chart creation, by taking their standard source data and create each chart via an automated macro.

Benefit

The Benefit

The benefit to the client was reducing a 3-4 hour job for staff down to less than 60 seconds! The client simply specified the charts they needed and how they wanted them displayed, and the macro we developed did the rest

 

 

Customer Feedback

"XLAutomation were very consultative in their approach to our needs, and I am very happy with the result. I would not hesitate to recommend their Excel macro services."

Tony Marlow - Research Director, Asia Pacific, Nielsen Online