Line Chart / Area chart

 Line Chart / Area chart

        Line chart or Area chart are used to show trends over time or categories.

• Select the range of data that you want on chat.

• Go to insert tab ➤ click on line chart from charts group.

• Insert any 2D or 3D line chart  ( in this example I choose Stacked line chart)

• Now excel immediately creates a chart and place it on your worksheet.

• Right click on the line to change the line color.
• Click on Format data series.

• A pane named Format data series appears.
• Click on fill & line (pain bucket icon) to change the line color.
• Click on solid line/ gradient line/ automatic (here I selected solid line)
• Click on outline color ➤ select any color.

• Click on marker to change the marker color.
• Click on marker options ➤ Built in➤ select marker type and size➤ click on Fill and select fill color ➤ click on border and select border color.

• Now your chart line looks like the below

For more format option click below  👇

chart elements, chart filters, chart styles

How to move and resize your chart

Column Chart