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...
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.
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?
