- Take sample data.
2. Go to ribbon, select Insert Tab and choose your chart type from the chart group.
3. Select your Chart type as 2-D Column.
4. The chart looks like below.
5. Now change 2nd column (here Net Proft Margin). Right-click on the second column and select Change Series Chart Type.
6. Now we take 2nd chart as line chart and place the secondary axis.
7. The chart looks like below
8. For changing the column chart color, right-click on the chart to Format Data Series then go to the fill to choose your color.
9. For changing the Line chart color, right-click on the chart to Format Data Series then go to the fill and choose your color.
10. To change the Marker fill color, right-click on the chart to Format Data Series then go to the fill and choose your color.
11. To change the Marker border color, right-click on the chart to Format Data Series then go to the Border and choose your color.
12. Change chart title. Click on the Chart Title and give your desired chart name.
13. To remove Gridline click on the chart. Click the + button, and remove the tick of gridline box.
14. The chart looks like below.
