Hi,

I tried to format but its not happening in a way which i want.

The data is like this

A1 20 30
B1 10 20
C1 15 25
A2 11 12
B2 12 13
C2 12 15

Due to overlapping of some of the values i was not able to differentiate.

"Andy Pope" wrote:

Hi,

One way would be to plot your x and y values in different series. Then
each series could be formatted to the required colour.

Cheers
Andy

zaka wrote:
I am trying to plot multiple color, multiple values, in scatter chart. Is
this possible to do.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info