Customizing Colours in Scatter Graph

Jenks

New Member
Joined
Nov 23, 2011
Messages
3
Hello,

I'm having some difficulties trying to customize the colours of separate plots in a scatter graph. I have 6 different data sets to put on one graph and am trying to make the symbols for the data points as follows:

- 1 set solid green circles
- 1 set open green circles
- 1 set solid blue circles
- 1 set open blue circles
- 1 set solid red circles
- 1 set solid red circles

The only issue I have is changing the outline colour of the shape. I can customize the shapes and fill colour, but I cannot change the colour of the outline of the shape from it's original automatic colour. Is there an easy way to do this? I would like to keep it as simple as possible without making the graph convoluted and hard to interpret. Any help is greatly appreciated!

Take care!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
you can do a green circle unfilled, and a green circle filled green.

So exactly what cannot you do? What is "the outline colour of the shape"?
 
Upvote 0
you can do a green circle unfilled, and a green circle filled green.

So exactly what cannot you do? What is "the outline colour of the shape"?

Sorry, I figured it out. When I would plot the data it would automatically assign a solid blue square for example. I could change the square to a circle and the fill colour to be green no problem, however a the blue outline of the shape would remain around the green fill. So it was a green circle with a blue border. When I tried to change the border colour it would connect all the data points with a line. I just did that then went into the "format data series" options to remove the lines connecting the points.
 
Upvote 0

Forum statistics

Threads
1,215,401
Messages
6,124,705
Members
449,182
Latest member
mrlanc20

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top