Windows XP XY Scatter Charts

S

stuanna

Joined
Feb 13, 2006
Messages
1
Reaction score
0
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XY Scatter Chart 1
Problem with xy scatter with dates 7
XY Scatter Pivot Chart in Excel 2000 2
OWC (office web component ) chart , stacked XY scatter 0
xy scatter charts - multiple points 3
XY scatter plot with more than 32000 rows in Excel 2003 0
xy scatter charts from pivot tables 1
XY scatter chart 2

Top