change size of data point in excel 365 chart

Question

None of the icons seems to have a way to change the size of the data points.

For example, I would like the triangles to be larger and maybe different color.

By the way, it would be nice for future versions of office to retain menus from older versions so we don't have to relearn what we already know. IMO Office 98 and 2003 had superior menus. Thank you!

Answer 1

Follow the steps in this article: https://support.microsoft.com/en-au/topic/change-data-markers-in-a-line-scatter-or-radar-chart-8e91c157-1c9c-4852-9657-1e2e1317f415

Andreas.

Answer 2

Marker Options was not found.

Just a comment regarding changing data series plots: I think previous versions had: Right click a data point and select Format Series where you could change anything about a series.

Answer 3

Marker Options was not found.

In some rare cases a chart might be corrupt (especially when created by VBA / AddIns).

Try to recreate the chart and check if the option is available.

If that doesn't work I need to see your file. Upload your file to an online file hoster of your choice and post the download link here.

Andreas.

Answer 4

Here's a new chart with the points in the chart 'selected'

and right clicked & selected "Format Data Series".

Answer 5

1. Select the series
2. Select the Fill icon
3. The Marker options appears here.

(I don't have an English Excel available at the moment, therefore I used your screenshot)

Andreas.