When I look at the built-in marker options in Excel, on of my running sessions offers cross as an option, another one does not. What could be causing this and how to fix this easily?
Using Excel 2016.
Screenshots
See the left side especially, the graphs themselves are not important, left them in for completeness.
When cross marker is offered
When it is not
I have tried searching online, but all the resources are pointing out how to change the marker type - I know how to do that, I don't know why I am offered different markers to choose from in two sessions.
42 Answers
The cross is present in both cases.
In the first case, the border of the marker is red, and the fill is either white or blank, so you can see the cross, the X, and the star.
In the second case, the border of the marker is red, and the fill color is also red. So the cross, the X, and the star all look like large red squares.
Change the fill color, preferably to none, and you will see the markers more clearly.
What version of excel do you use?
The series markers for charts with multiple series in Excel 2013 all default to the same marker.
However, in Excel 2010, each series is assigned a different tag style by default.
If you need them to be consistent, you can change it manually:
Double click the series to open the format pane. In the format pane, select the paint bucket icon to go to the color and fill section. Here, click "Marker" to reveal the options for series markers.
