Question

Explain what each of these Excel chart elements are and provide an example of how to access one of those items.

• Data Marker
• Data Series

Answer 1

Data Marker : A column, dot, pie slice, or other symbols in the chart that represents a data value are data makers.

For example in a line graph below, each blue point on the line is a data marker representing the sale of coffee or the  data value located in a worksheet cell

.

Coffee sales units 600 500 400 300 200 100 cold brew frappecino Espresso Latte mocha

How to access a data marker :

1. Right-click the line to which you want to add data markers .
2. Select format data point.
3. Click the button with the paint can icon.
4. Click the “Marker” button.
5. Expand the “Marker Options” section.
6. You will see 3 options which includes auto, none and built in
7. Select the “Built-in” option.
8. In the “Type” list, choose the type of marker you want to use.
9. In the “Size” list, select the size of the markers.
10. Make other customizations to the markers as desired.

2) A data series is a row or column of numbers or data that are entered in a worksheet and plotted in your chart, such as a list of sales or year. For example, Below is the data series for coffee type and sales units which is represented on the chart.

Coffee sales units
Coffee type	sales units
Espresso	237
Latte	482
mocha	239
cold brew	458
frappecino	548

Coffee sales units 600 500 400 300 200 100 cold frappeci Espresso Latte mocha brew no Coffee salesunits sales units 237 482 239 458 548 Salesin units