Turn on the keypad lock function by pressing the “Number Lock” button. You can only enter the degree symbol using the number pad (not the number line above the letters.) Step 2Ĭlick in the cell where you want to enter the degree symbol. The picture continuously to represent how many was due to the large number in the cafe exercise the picture would turn out to small.Use the “Alt” key to insert ASCII or Unicode characters. 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. Solid colour in a graph or background as the colouring 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. 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 Simply highlight the text you which to change, and change the size, style and colour. 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.
Step8: Change the title of the graph to Profits. Select data that is shown belowĪfter selecting the data click the button then click the this will put the information into the graph. Then to select the data range click Amour Cafe tab (for the worksheet). Click the edit button which is under Chart Data. Step6: Using the format palette edit the data range. 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. This will display the percent in the Pie chart.
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. Step7: Name the chart Percentage of sales. The pie chart gives a better viewing of the percentages. 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.
Use the drop down box to bring up the Axis. To do this go to the Chart options area on the format palete. Givve the chart the title of Products Sold, give the vertically axis the title Amount sold then give the Horizontal axis the titile Product. Step7:Ĭhange the chart and the axis titles. Select data that is highlighted in red below.Īfter selecting the data click the button then click the this will put the information into the graph.
Step5: Using the format palette edit the data range. (Options are the different charts available to use).įor the first graph we will be using a column graph. Step3: To get chart options up, go to the top tool bar across to insert, then go down to chart. To do this double click on the sheet part down the bottom. Sheet with the table name Amour Cafe and the sheet that will have graphs, call it graphs. Creating Graphs in Microsoft Excel Graph One Step1: Continuing on from the table, create a new work sheetĬlick the + symbol at the bottom of the screen
0 kommentar(er)
