Click edit and add the date range column
Name the macro ‘ChartGenerator’
While the macro is recording, complete the following steps:
5. Right-click on the chart area and click Select Data. Under Horizontal Axis labels, click Edit and add the date range in column A. Click OK when complete. 6. Change the colour of the line to red.
7. The title is automatically in bold type, remove this bold type.
C. If you get an error, click Debug. This will take you to the line of code that contains the error.
D. Run the macro again until it is performing all of the automatic edits error-free. You may need several tests before you get it completely error-free. It is better to get this part fully functioning than the next part. Focus on getting this right before you create the user form.
4. Set the Cancel property of the Cancel button to True.
PHASE THREE: Handling user input
3. The second line of code should call ChartGenerator(inputRange).
4. Back in the main module, set the ChartGenerator macro to take the chosen data range as an input. Then specify this range as the source data in the line of code that begins ActiveChart.SetSourceData
Submission Date: January 9th2018
