Creating Graphs In Excel (mac)

Creating Graphs in Microsoft Excel Graph One Step1: Continuing on from the table, create a new work sheet

Click the + symbol at the bottom of the screen

Step2: Rename both the sheets. Sheet with the table name Amour Cafe and the sheet that will have graphs, call it graphs. To do this double click on the sheet part down the bottom.

Step3: To get chart options up, go to the top tool bar across to insert, then go down to chart. Click chart and options will appear. (Options are the different charts available to use).

Jacqueline McAlister

Step4:

For the first graph we will be using a column graph. Click the option on the bar above. Choose any of the column graph options. Step5: Using the format palette edit the data range. Click the edit button which is under Chart Data.

Step6: Click here

Then to select the data range click Amour Cafe tab (for the worksheet). Select data that is highlighted in red below.

Jacqueline McAlister

After selecting the data click the button then click the this will put the information into the graph.

button,

Step7: Change the chart and the axis’ titles. Givve the chart the title of “Products Sold”, give the vertically axis the title “Amount sold” then give the Horizontal axis the titile “Product”. To do this go to the Chart options area on the format palete. Drop down box Type text in here

Jacqueline McAlister

Use the drop down box to bring up the Axis’. Then type the headings in the box below. Graph Two Step3-6: Are the same as before except this time use a Pie graph as we need to find the percentages of the amount sold. The pie chart gives a better viewing of the percentages. Step7: Name the chart “Percentage of sales”.

Step8: To display the percent of sales. Go to the chart options section, down to other options, there is a drop box next to Labels: click the drop box, and then chose the option Percent. This will display the percent in the Pie chart.

Graph Three Step 3 – 5: Same steps as the last two graphs but the chart used this time will be a Bar Graph; this graph will show the profit of the business from daily to month to the year using the worksheet Amour Cafe. Jacqueline McAlister

Step6: Using the format palette edit the data range. Click the edit button which is under Chart Data.

Step7: Click here

Then to select the data range click Amour Cafe tab (for the worksheet). Select data that is shown below

.

Jacqueline McAlister

After selecting the data click the button then click the this will put the information into the graph.

button,

Step8: Change the title of the graph to Profits. Fonts and colouring Step1: Fonts can be changed by going to the top of the format palette box abd clicking the Font drop down box. Simply highlight the text you which to change, and change the size, style and colour.

Step2: Colouring the graphs, can be done by clicking the graph or background that you wish to colour/format, then click the Format button on the top menu bar, then

Jacqueline McAlister

choose Data Point.

Step3: You can format the individual sections of the graphs, if you choose to colour each bar for example in a bar graph then in the key box it will show the colour and what the colour represents.

Solid colour in a graph or background as the colouring

Jacqueline McAlister

Using a gradient

You can use a picture as the colouring on a graph, Textures that are already on the loaded on you can chose to stack the pictures that will display the program. The picture continuously to represent how many was due to the large number in the cafe exercise the picture would turn out to small.

Examples of finished Graphs from the exercise:

Jacqueline McAlister

Jacqueline McAlister

Jacqueline McAlister