In this tutorial we learn that how to format chart in excel. Microsoft excel provide strong formatting facility for charts. To format chart use format menu from menu ribbon. By using format menu you change the background of the chart. To format chart first select that chart you want to format. You also create customized chart style in microsoft excel. For customized background by using format menu select fill color option and adjacent options custom background applied to the chart.
format chart in excel example:-
Now format a chart of salary sheet created in previous tutorials. You did not select chart so format menu is hide.
Select fill shape option and select color to customize background.
For customize color select more fill colors.Now color apply on the chart which selected by you.To change the shade of background select option gradient from fill shape.After selection of gradient chart become as following.You also change the border color of the chart by using next option of fill shape named as shape outline.
You can change color of border by using the color. To change border line style select dashes and to change border line width select weight. First select border color red from theme colors and chart show as following.