Graphical Reports, built from Excel File

We have a large Excel data file that we currently divide manually to produce a graphical analysis for our client. We need a macro process to conduct the division and presentation of graphical data, without the human intervention.