Hi all,
i'm trying to create a scatter chart in VBA with 3 sets of data, but I have some issues that I can't solve:
- the legend should be aligned with the top of the chart
- the forecolor of the markers is always blue instead of red/green
- remove the countour lines from markers
- Each point should have a label taken from the columns J and O, instead appear labels from columns I and N
- the axis labels should be bold
I've attached the file with code. You'll see two charts, the first is the output of the code, the second is the correct one.
thanks in advance for any advice
Bookmarks