Creating A Chart In Excel. The sub-type menu displays. When you insert a chart into Word or PowerPoint an Excel worksheet opens that contains a table of sample data.

Click the desired chart sub-type. On the View menu click Print Layout. For this example I have taken sales data as an example.
So well select the 5 marks and 1 mark columns to plot a column chart.
Enter Data into a Worksheet. The following article details you how to create charts in Excel 2013. It will open a SmartArt Graphic dialog box for various options as shown below. Excel tutorial on how to make a Flow Chart in Excel.