Microsoft Excel 2010 features a tool set that offers you the option of performing assorted functions on your data, including turning that data into a graph. Your Excel graph will be inserted into your worksheet as an image separated from the worksheet, which allows you to resize the graph to fit your needs. However, as the actual size of your graph may be important in relation to your data, you can adjust the size of the graph to keep it relative to your data.
Double-click the Excel file containing the information you wish to use for your graph.
Click on the top-left cell containing the data for your graph, and then, while holding down the mouse button, drag the blue box until all your desired data is selected.
Click the “Insert” tab at the top of the window.
Select the type of graph that you wish to create from the “Charts” section of the ribbon at the top of the window. The graph will be generated and displayed in the center of the window, and a new set of tabs will be visible in the “Chart Tools” section at the top of the window.
Click the “Layout” tab in the “Chart Tools” section at the top of the window.
Select “Format Selection” in the “Current Selection” section of the ribbon.
Click “Size” in the column at the left side of the window.
Adjust the “Height” and “Width” percentage values of the “Scale” section to adjust the size of the graph relative to its’ default size. The default value is “100%” for both values, so, for example, changing these values to “50%” would make the graph half of its original size.