Hello.
I have an Excel spreadsheet with a sheet containing data to plot on a separate sheet using a 'scatter with straight lines' chart.
I would like to create a Macro which automatically carries-out this task.
The data consists of line items with planned and actual finish dates. Both planned & actual need to be plotted.
There are two sets of data, called Phase 1 and Phase 2. I would like separate scatter charts to be generated for each set.
The vertical axis needs to be converted to % of line items, if possible.
Sheet with Data
Desired output - two scatter charts for Phase 1 & Phase 2 with planned and actual finish dates. So two lines on each chart.
I have an Excel spreadsheet with a sheet containing data to plot on a separate sheet using a 'scatter with straight lines' chart.
I would like to create a Macro which automatically carries-out this task.
The data consists of line items with planned and actual finish dates. Both planned & actual need to be plotted.
There are two sets of data, called Phase 1 and Phase 2. I would like separate scatter charts to be generated for each set.
The vertical axis needs to be converted to % of line items, if possible.
Sheet with Data
Desired output - two scatter charts for Phase 1 & Phase 2 with planned and actual finish dates. So two lines on each chart.
