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
Max
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.
How about a count of how many at each amount instead? Can that be done. thanks for the help in advance
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks