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 diffe...
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.
Hi Hans, I really have no idea how macros and VBA works. An error pops up when I click on the 'create chart' button. In any case, how could I implement it into my real dataset?
I think this version should work on a Mac.
Hi Hans, thank you, that's very helpful. Although I'm not sure how I can translate that to my real data. Did you change the shape of each marker manually?
I'm terribly sorry, I should have seen that you're on a Mac - you did indicate that in the first post. I used a Windows-only feature. I'll have to think about a replacement.