Chart in Ms-Excel 2013


Chart in Ms-Excel 2013

Chart in Ms-Excel 2013

Charts –                 When data is represented by symbols, bars, lines or slices in 3D sphere or circle, these graphical area or map are called chart. Chart is an easy way to represent in Graphical or Pictorial format of a large amount of data without any long reading job with tedious movement. Chart save the time to understand large data/record.

There are many types of chart as following –

1.    Column Chart

2.    Bar chart

3.    PI chart

4.    Line chart

5.    Area chart

6.    X Y (Scatter) or Bubble chart

7.    Surface Chart

8.    Stock Chart

9.    Radar chart

10.  Combo chart

Some popular Chart with it steps are –

Select the data area and click on any proper chart type, it display on the current sheet as-

Column Chart- 

Column Chart in excel 2013


Bar chart - 

Bar chart in excel 2013

Pi chart - 
PI chart in excel 2013

Line chart - 

Line chart in excel 2013

In any chart, a flag option will appear when chart is selected, it contains three options –  

Chart Element –       This option used to add, remove or change some chart element like, Chart title, legend, X-axis, Y-axis value, Major/Minor gridline, data label and other elements.

Chart Styles –           This option used to change the color of chart background, foreground, with given different style of color scheme and chart styles.

Chart Filters –          This option used to show/hide the field and its value in chart according to given as table field. You can also display data value, its percentage and other element.




0 comment(s)

Leave a Comment