I’ve had some really good help from this site in the past so I’d like to ask another question.
I have a set of 5000 data points for 2 conditions put in columns A and B. I use the normal scatter plot in Excel to generate a graph but all the data point overlap making it impossible to see if there is an area of greater overlap within the data.
What I’d like to do is create a density plot of the same data, so that the more points that piled on top of each other the brighter the colour. Is that possible in Excel?
Many thanks for your help