Can u set up a chart like this

[jsw469]

Below is a small sample of the data. I am trying to setup Scatter Graph. What I am trying to see if there is a way to break up Colunm B to where u can use a scatter. Or some what to create multiple ranges if it has The site number in it.


Day(A) Site (B) Amount(c)
1 Site 1 376
2 Site 1 503
3 Site 1 452
4 Site 1 235
5 Site 1 191
6 Site 1 353
1 Site 2 276
2 Site 2 403
3 Site 2 352
4 Site 2 135
5 Site 2 91
6 Site 2 253

 

[Gerald Higgins]

What exactly do you mean ?
Do you mean have one series for Site 1, another for Site 2 and so on ?