Forum Discussion
Calli99
Dec 11, 2022Copper Contributor
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...
HansVogelaar
Dec 11, 2022MVP
I think this version should work on a Mac.
Calli99
Dec 11, 2022Copper Contributor
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?
- HansVogelaarDec 11, 2022MVP
No, the macro changes the shape of the markers according to the field.
The macro can handle any number of data rows, with any number of groups, and currently up to 6 fields (although that could be expanded to 9 if required).
- Calli99Dec 12, 2022Copper Contributor
Thank you Hans, how can I add this macro into my file with my real data?
- HansVogelaarDec 12, 2022MVP
Are your real data also in columns A to D, starting in row 2 (headers in row 1)?