Excel Macro/VBA needed
$250-750 USD
Paiement à la livraison
The requested project is – create an Excel macro/VBA that will:
1. Automatically create charts from excel data
2. Automatically copy the created charts to MS Powerpoint and/or Word.
The Excel Macro/VBA should be relative to support different amounts and types of data.
This project is based on 2 Excel files - the "project" macro excel file for managing the project declarations and "Data1" Excel file that includes "raw data" for creating Excel charts (each sheet for each chart):
1. "Project" - Excel Macro file – this file is for managing the project declarations:
a. Data File - the name of the Excel file with the raw data for the charts
b. Output File - pptx (optional field) - if this field is not empty, then the charts made in the Data file are copied to the specified Powerpoint file. If this field is empty then nothing has to be copied.
c. Output File - docx (optional field) - if this field is not empty, then the charts made in the Data file are copied to the specified Word file. If this field is empty then nothing has to be copied.
d. Color1...Color15 (optional fields) - This are the colors (in R,G,B) that are used in the charts created. If these fields are empty then default Excel colors are used for the charts.
e. Chart headline (optional TEXT field) - if this field is not empty then these should be the headlines for the charts crated.
f. Sheet - This are the Excel sheets in the data file in which the chart raw data is stored.
g. Chart Type - This is the chart type used for creating each chart
h. Number [n] (optional TEXT field) - if this field is not empty then this text should be copied with the created chart to the Powerpoint and/or Word file
i. Dates (optional TEXT field) - if this field is not empty then this text should be copied with the created chart to the Powerpoint and/or Word file
j. Remarks (optional TEXT field) - if this field is not empty then this text should be copied with the created chart to the Powerpoint and/or Word file
2. "Data1" Excel file:
a. Sheet1 – Name of the report
b. Sheet2…Sheet[n] –Raw data for the Charts
Nº du projet : #4339495
