If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.
I am trying to make a scatter chart that shows each point. Since several values are the same they keep bunching up on the chart. Is there some way to spread them out.
I have attached a file with a few points. Basically it is by month and amount. Any help is appreciated
I don't think it's appropriate for a chart. Surely there must be something that differentiates these values? If you have identical values I guess Excel cannot help but superimpose them.
Yes, you could do a pivot table which would summarise the amount data and then do a chart based on that, but you'd be showing a different thing so it depends on what you're trying to show.
Best to use a data label to display occupancy count of each point.
Sometimes you can 'jitter' the data values in order to spread them, but as both you axes are values this could, and probably will, result in the chart being mis-read.
Linear Mode
