VBA Macro for MS Excel to create Charts

From a single spreadsheet containing a set of uniformly formatted data this macro will need to create a series of specific frequency graphs. The number of rows will vary, also some of these charts will by data on a single row (repeated down all the rows eg. 100 rows it will need to generate 100 charts, 120 rows it will need to generate 120 charts), and some of these will be based on multiple column data for all the rows. Some of the charts will also require data frequencies to compare by the value in a particular column. Some of the charts will require only selected columns based on the value within a particular column. Charts will need to exclude null values in any cell. All of the charts are very easy to do within Excel however the real guts of the work is in the automation of the generation of these charts based on the variable number of rows. A full specification will be provided complete with a test spreadsheet containing examples of all variations within the data, and examples of each chart. Headers and Labels will be included and these must be specific to each chart type. NOTE THE INDIVIDUAL GRAPHS WILL NO LONGER BE NEEDED WITHIN THIS PROJECT. ## Deliverables 1) Complete and provide a fully-functional .bas file to the provided specification. 2) Complete ownership and distribution copyrights to all work purchased. ## Platform This must run on MS Excel 2002. ## Deadline information The work must be completed within 7 calendar days of the coder receiving a the final specification, example graphs and test data.