How to Make a Monthly Budget Circle Graph

Circle Graph in Three Dimensions
••• http://www.wecdsb.on.ca/206/gr8/Pie_Graph.gif

Creating a monthly budget circle graph is an effective way to plan spending each month and is rather easy to do on a computer. Using the Microsoft Excel program, a circle graph is easy to customize to one's business needs and is just a few clicks away.

    Input the budget data into the given Microsoft Excel cells vertically. Since you are making a circle graph, the data will add up to 100%, but not necessarily the number 100. The data should fill cells A1 and downward.

    Click "Insert" at the top of the screen, move the mouse down to "Chart" and click.

    Choose the "Pie" option for the type of graph. This is under Step 1 of the "Chart Wizard." Click "Next" at the bottom of the window.

    Click the symbol to the right of the blank labeled "Data Range."

    Drag the mouse across the data in the cells behind the window. To reenter the "Chart Wizard," click the symbol to the right of the blank again.

    Click the "Series" Tab at the top of the window. Name Series One the first budget item.

    Add series as needed to fit the budget items on the list. Press "Next" when finished.

    Title your chart by filling in the "Chart Title" field.

    Click "Finish" to create the circle graph.

    Optimize the budget graph as needed by right-clicking it. When finished, print the graph.

    Things You'll Need

    • Computer
    • Printer
    • Microsoft Excel software

    Tips

    • There are several versions of Microsoft Excel, so if a term seems different, find the closest related term. For instance "Pie Graph" may be called "Circle Graph" in some versions.

    Warnings

    • Be sure to correctly enter the data before creating the graph. If this is not done correctly, the graph will not accurately represent the data.

Related Articles

How to Make Excel Calculate the Graph's Slope
How to Calculate Correlation Coefficient Between Two...
How to Create a Population Graph
How to Work Out Percentages in Excel
How to Reset a TI 89 Titanium
How to Solve a Quadratic Equation With a Casio Calculator
How to Program Equations with the Casio FX-115ES
How to Make a Relative Frequency Table
How to Graph a Distribution for a T-Test
How to Do the Coding Speed Test on the ASVAB
How to Calculate a Semivariogram
How to Make a Coordinate Plane in MS Excel
How to Use a Graphing Calculator
How Do I Calculate the Relative Standard Deviation...
How to Calculate Battery Voltage
How to Find Correlation Coefficient & Coefficient of...
Roles of Cell Organelles in Mitosis
How to Subtract Matrices on Excel
How to Draw an Array in Math
Which Cell Organelle Stores DNA and Synthesizes RNA?