Select cell 'B1' and enter the number for the first year that you want to compare.

Continue down the column, entering all of your data periods into different cells. Click on cell 'A2' and enter the first period, such as 'Quarter 1' or 'January,' for which you have data. Click on 'Year' from the list on the left side of the window, and click 'Remove.'Ĭlick 'OK' to close the Select Data Source window, and your graph should now correctly show your data by year.

Click 'OK' to go back to the Select Data Source window. Click and hold the mouse button on cell 'A2,' then drag the mouse down to the bottom of your list of years. A small window will appear.Ĭlick 'Edit' under the 'Horizontal Axis Labels' heading on the right side of the window. Click the 'Select Data' button, located on the ribbon. Select the chart, then click the 'Design' tab at the top of the screen. The chart will appear on your spreadsheet. Choose your desired type of chart from the options that appear when you click the button. Click on the 'Column,' 'Line' or 'Bar' buttons, as these are the only three types of charts that will work well with this kind of data. Click the 'Insert' tab at the top of the Excel window. Do the same thing down each column until you have entered all of your data.Ĭlick on any cell where you have entered data. Click on cell 'B2' and enter the data that corresponds to that first year. ( on cell 'A2' and enter the first year that you have data for. It can be added in worksheet part as below,ĭrawingsPart = worksheetPart.AddNewPart() To insert any type of drawing objects in office documents DrawingsPart is base part in which we append child elements.ĭrawing part is a common object in all sheets of spreadsheet. We will go through various chart objects in the following sections, We are going to talk about drawings and the chart parts in this blog. Spreadsheet documents in OOXML mainly contain following parts, An OOXML file is stored in zipped, XML files. Open Office XML (also known as OOXML or OpenXML) is a XML based file format developed by Microsoft for representing office documents.

How to plot a graph in excel 2010