Primary Minor Vertical/Horizontal, Primary Major Vertical/Horizontal is the types of gridlines.

Gridlines: Horizontal thin lines shown in the above chart are Gridlines.These are Standard Error, Standard Deviation, and Percentage mainly. Error Bars: This shows the kind of error and amount of error the data has.Data Table: Data Table is the table that has data used in creating a line chart.Connecting data labels creates line charts in excel. Data Labels: These are the datum points in the graph, where the line chart points are pointed.Here, it is mentioned as “Quantity Sold.” Chart Title: Chart title is the heading of the whole Chart.We can choose/write any text in this title box. Axis Title: Axis Title as it is mentioned beside Axes and bottom of product types in the line chart.It represents the range under which data may fall in. Axes: These are numbers shown in Y-axis.Here, we have already checked some of the elements for an explanation. Once we do that, we will get Chart Elements, as shown below.

As we can see, there are some more options available at the right top corner of the Excel Line Chart, by which we can do some more modifications. Let’s see all the available options one by one.įirst, click on a cross sign to see more options.

Create line chart in excel for mac