How to Create Line Chart?

Take sample data.
Go to the ribbon, select Insert, and select your chart type from the chart group.
Select Chart type as 2-D line.
The chart looks below.
To give Tick Mark in the horizontal axis, right-click on the axis and select Format Axis.
Select Tick Mark Outside or another option from the Axis option.
To change the Tick mark color, in the Format Chart Area, select Fill, and choose your color.
To change the Line color, right-click on the chart and select Format Data Series.
After that select Line Option and choose your color.
To change the Marker Fill color, select the Marker Fill Option and choose white color.
To change the Marker border color, select the Marker border Option and choose your color.
To smooth the Line, in Format Data Series select Series Option and tick the smoothed line box.
To Remove Gridline, click on the chart then select the + button, and uncheck the Gridline.
To give Data Labels click on your chart and select the + button to give your Data labels. Select Data labels and click on Above or any other option.
To change Chart Title, click on the title and give your appropriate name.
You can change the marker size and type. Right-click on the chart and select Format Data Series. Select Series Option and choose Marker Option, here you can change Marker Type and Size.

Leave a Comment Cancel Reply

Categories