Add a Diverging Colour Gradient to A Scatter Plot in Excel (VBA)
- or -
Post a project like this1725
$
- Posted:
- Proposals: 4
- Remote
- #2466596
- Awarded
Description
Experience Level: Entry
I have a scatter plot of simulated data. I want to colour in the data points so that the upper half change from white to blue, and the lower half change from white to red, in a smooth gradient (see Figure 1 attached).
Someone has already posted their VBA code for how to achieve this in Excel, but I don't use visual basic. I am looking for someone who knows VBA to apply this code to my scatterplot (or to use any code they wish to achieve the desired result, as long as it is in Excel).
Original solution:
https://stackoverflow.com/questions/35624585/coloring-each-point-of-a-chart-based-on-data-using-sequential-or-divergent-color
Github materials with VBA code:
https://github.com/DanGolding/Scatter-plot-with-color-grading-in-Excel
Please let me know if you have any questions!
Someone has already posted their VBA code for how to achieve this in Excel, but I don't use visual basic. I am looking for someone who knows VBA to apply this code to my scatterplot (or to use any code they wish to achieve the desired result, as long as it is in Excel).
Original solution:
https://stackoverflow.com/questions/35624585/coloring-each-point-of-a-chart-based-on-data-using-sequential-or-divergent-color
Github materials with VBA code:
https://github.com/DanGolding/Scatter-plot-with-color-grading-in-Excel
Please let me know if you have any questions!
Matthew C.
100% (6)Projects Completed
4
Freelancers worked with
3
Projects awarded
29%
Last project
22 Oct 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies