Breaking News

Display a Chart of Table in Microsoft Office Exel 2013

Now I will write an article about display a chart of table in microsoft office exel 2013.

Please open your exel document that you want to display a chart. And then block the table. For example I use table like this.


Click the Quick Analysis button in the bottom left corner of the table. The display like this.



Click Charts Tab. And then choose the chart model you want.


For example I choose Clustered Column style. The display like this.


Click Chart Styles icon in the top left corner of the chart. Choose the style you want, for example I choose the style 9. The display like this.



If you want to filter the data you want display you can click Chart Filter icon in the top left corner of the chart. Check the data you want display. 


For example I just check Pencil, Book and Pen. After that click Apply. The display like this


Okay, it is a way to make quickly charts in Microsoft Office Exel 2013. Hope it is useful.

No comments