Computer Science, asked by piulovelygirl, 4 months ago

how do you create and delete a chart in excel​

Answers

Answered by chaudharim10
3

Explanation:

Delete a chart

Click the edge of chart's frame to highlight the chart.

On the Home tab, in the Editing group, click Clear > Clear All. Tip: For faster results, you can also press Delete on your keyboard.

create chart in excel

Let’s see how we can do this with the help of the spreadsheet.

Step 1: Open MS Excel.

Step 2: Go to Menu and select New >> click on the Blank workbook to create a simple worksheet.               

OR – Just press Ctrl + N: To create a new spreadsheet.

 Step 3: Go to the spreadsheet work area. Which is sheet1.

Step 4: Now create headers for Sales in each quarter in the first row by merging cells from B1 to E1 and in row 2 give the product name and each quarters name.

Step 5: Now write down all product name in column A.

Step 6: Now provide the sales data for each quarter in front of every product.

Step 7: Now in the next row put one header for Grand Total and calculate each quarter total sales.

Step 8: Now calculate the grand total for each quarter by summation >> apply in other cells in B13 to E13.

Step 9: So let’s convert the sales value in the ($) currency symbol.

 

Step 10: Now create a Result Table in which have each quarter total sales.

Step 11: Now plot the pie chart to represent the data to the client in a professional way which looks attractive. A user can change the looks of the graph by just clicking on it and their option will appear and he can choose one which he likes.

mark as brainliest

plz

plz

plz plz

plz

plz

plz

plz

plz

plz

plz

Answered by manjusharma99146
2

How do you create a chart in excel? hope this is helpful thanks

Attachments:
Similar questions