data points

[affordablegreen]

I have a scatter chart with the following info : sales price, square
footage, and subdivision. With the x and y axis being sales price and square
footage. There are some entries where i will have several sales in one
subdivision and i would like all those points to show up in the same color.
How do i get several points to show up in the same color instead of excel
assigning each entry a new label?

 

[David Biddulph]

Include all the related points in the same data series, rather than as a
different data series for each point.