Scatter Chart - Different Colors

[silver3502]

Hi,

I have set of data and need to create scatter chart with two different color data sets

1. Basically I want to create a scatter chart with below data. Use 'price' as Y axis
2. If middle 'Sid' column got B then data point in scatter chart should be in blue
3. If middle 'Sid' column got S then data point in scatter chart should be in red.

Can we use any formula or vba to achieve this...thanks in advance.



[TABLE="width: 265"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Description Sid[/TD]
[TD][/TD]
[TD] price[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]B[/TD]
[TD="align: right"]345.25[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]B[/TD]
[TD="align: right"]335.25[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]B[/TD]
[TD="align: right"]330.25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]B[/TD]
[TD="align: right"]349[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]B[/TD]
[TD="align: right"]349.5[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]B[/TD]
[TD="align: right"]351.25[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]B[/TD]
[TD="align: right"]350[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]B[/TD]
[TD="align: right"]349.25[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]352[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]351.75[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]381[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]376[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]363[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]422[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]409[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]424[/TD]
[/TR]
[TR]
[TD]Hog Dec17[/TD]
[TD]S[/TD]
[TD="align: right"]420[/TD]
[/TR]
</tbody>[/TABLE]

 

[silver3502]

any one can assist?

 

[thisoldman]

Are you sure you want a scatter chart? I assume you want Price on the vertical, on the y-axis. What is supposed to be on the horizontal, the x-axis?

No matter what type of chart, to give B one color and S a different color requires two chart series—two different columns of data. Here are two different line charts using the data you posted. These two charts are not the only ways to plot the data.

Are either of the charts close to what you want?