VBA Format for Scatterplot

Hi all! I am designing a database for work to create a scatter plot chart based on supplier ratings from 1-10. I recently found coding with VBA that labels each point with the names of the suppliers on the chart at the address:

http://excel.tips.net/Pages/T003503_...ter_Plots.html

However, problem one now is that I don't know how to manipulate the code and need to change the formatting (font, size, ect)

Also, problem two I have is that I only want some of the points labeled and the others to just be points not labeled zero.

My excel worksheet is set up with:
column A as the company names
B: x-axis points
C: y-axis points

I need two parts to the formatting of the chart:

1. A gradation of green to yellow to red fading from the bottom left corner to the top right
2. Curved lines connecting the 3,5,7,10 on the x-axis to the 3,5,7,10 on the y-axis.
3. Then of course the text labeling of only some data points.

The code that I found is:

Please Login or Register  to view this content.

If anyone can point me in the right direction I would really apreciate it! I am lost with programing Thanks so so much for your help!!!