Split Excel Data & Produce Visual Report With Graphs

We have a significant amount of excel data that is currently divided manually and compiled into a client friendly format, which includes graphs to exhibit the data.

Currently, it takes a day to compile the report manually. We would like an Excel macro process to divide the data and produce the client report in a suitable format.