Forum Discussion
Scatter plot with different marker shapes and colours
Hello,
I am trying to make a scatter plot using 4 different variables: Field, X value, Y value and Group.
I would like the markers to have different shapes according to their Field, and different colours according to their group, but I don't know how to incorporate the Group into the plot. At the moment I just have a plot with the different Fields identified by different colours.
Please can anyone help?
12 Replies
For a small chart like this one, I'd simply format the points manually - see the attached demo.
- Hi Hans, thanks for the response. The screenshot I used was just an example of similar data, I actually have about 25 different points over 5 different 'Fields', just enough to make doing it manually quite annoying (although maybe just small enough that I could cope with the frustration!)!
The attached version contains a macro that will create the chart for you. You'll have to allow macros when you open it.
