Enter the desired category data for the information you want to compare in the A column. Each category should be in a cell beginning with A2. In the example below, I used Fuel, Clothing, and Entertainment costs.
Next you should type in the x-axis labels into row 1 that you want.
Each label should be in a separate cell beginning with B1. In the
example below, I typed in the four months that were being tracked.
Enter the values you want for the y-axis data in the correct data cells.
The data should correspond to the correct x-axis and category. In my
example I entered the amount of money spent for each item for each month
rounded to the nearest dollar.
Highlight the data in the
spreadsheet by clicking on the upper left hand corner of the data table,
then drag the mouse across the entire data range.
Click on the “Insert” Tab in the menu at the top of the screen. This will be the second tab from the left
Click on the type of chart that you want to use to represent your data.
For my data, I used a Bar graph because it’s good at showing different
x-axis variables that represent different data. Many graphs portray data
differently. I will have more information on this in my tips section.
The types of charts are listed in the middle of the tab menu such as
Column, Line, Pie, Bar, etc. A drop-down menu of Bar Chart designs will
be shown after you click on one of them.
Select the type of chart that is best suited for the display you want.
When you put your mouse over the chart option, you'll see a description
of what the chart display is good for.
For example, select “2D Bar” in a
clustered column for the type of chart. The chart will appear on the
spreadsheet using the data in a 2D form.
Click on your graph and and then click on the layout tab.
To add graph titles or axis titles simply click on the titles tab. A
drop-down menu will appear where you can choose the one you prefer.
Make changes to the chart as needed in the title, legend, fonts, etc. by clicking on the text and editing it.
After you are done formatting and editing the graph you can copy and paste it into other documents. If copy and pasting doesn't work you can always try taking a screen shot of the image and inserting into the selected document
No comments:
Post a Comment