Hi,
I am trying to compose a Scatter Chart but some of the values are the same so therefore overlap onto eachother.
I can only think of two ways to solve the problem
1. Some tool within the scatter chart function that separates the dots.
or
2. Some formula in the data series that adds 0.1, 0.2 etc to values that are the same therefore 'bunching' the dots on the chart around the general area (have spent alot of time trying to figure this one out but cannot seem to find the correct combination of IF, LOOKUPS, COUNTIF etc.
Would be very grateful for your help
Thanks
Anna
I am trying to compose a Scatter Chart but some of the values are the same so therefore overlap onto eachother.
I can only think of two ways to solve the problem
1. Some tool within the scatter chart function that separates the dots.
or
2. Some formula in the data series that adds 0.1, 0.2 etc to values that are the same therefore 'bunching' the dots on the chart around the general area (have spent alot of time trying to figure this one out but cannot seem to find the correct combination of IF, LOOKUPS, COUNTIF etc.
Would be very grateful for your help
Thanks
Anna