sanjib85
09-05-2016, 11:37 PM
I want to create scatter plot chart by VBA code in excel. Please help me what will be the vba code to create the scatter plot chart. Please find below the database and chart format also attached with the excel file.
Partner Name
Capability + Capacity (Y- Axis)
Commitment (X- Axis)
Datacom Systems Pty Ltd
140
68
iQ3
140
76
Blue Apache Pty Ltd
175
55
The Somerville Group Pty Ltd
111
56
Fujitsu Australia Ltd
152
62
SureBridge Pty Ltd
119
38
The Somerville Group Pty Ltd
153
61
Qbit
93
60
Codeblue Ltd
125
43
Thomas Peer Solutions
123
93
Insight
140
79
The Missing Link
109
50
Fujitsu New Zealand
142
55
Ethan Group Pty Ltd
150
66
Blue Connections
135
67
Partner Name
Capability + Capacity (Y- Axis)
Commitment (X- Axis)
Datacom Systems Pty Ltd
140
68
iQ3
140
76
Blue Apache Pty Ltd
175
55
The Somerville Group Pty Ltd
111
56
Fujitsu Australia Ltd
152
62
SureBridge Pty Ltd
119
38
The Somerville Group Pty Ltd
153
61
Qbit
93
60
Codeblue Ltd
125
43
Thomas Peer Solutions
123
93
Insight
140
79
The Missing Link
109
50
Fujitsu New Zealand
142
55
Ethan Group Pty Ltd
150
66
Blue Connections
135
67