How do I add Y axis labels in Excel?

Click the chart, and then click the Chart Layout tab. Under Labels, click Axis Titles, point to the axis that you want to add titles to, and then click the option that you want. Select the text in the Axis Title box, and then type an axis title.

How do I learn Microsoft Excel quickly?

How to master Excel quickly in 11 steps

  1. How to navigate the interface.
  2. Learn some useful shortcuts.
  3. Freeze panes.
  4. Learn how to master Excel formulas.
  5. Create a simple drop-down list.
  6. Visualize key data with conditional formatting.
  7. Flash fill.
  8. Summarize data with PivotTables.

How do you calculate weightage?

To find a weighted average, multiply each number by its weight, then add the results. If the weights don’t add up to one, find the sum of all the variables multiplied by their weight, then divide by the sum of the weights….2. Multiply the weight by each value

  1. 50(. 15) = 7.5.
  2. 76(. 20) = 15.2.
  3. 80(. 20) = 16.
  4. 98(. 45) = 44.1.

How do you assign weight to data?

To calculate how much weight you need, divide the known population percentage by the percent in the sample. For this example: Known population females (51) / Sample Females (41) = 51/41 = 1.24. Known population males (49) / Sample males (59) = 49/59 = .

How do I add a vertical and horizontal axis title in Excel?

If you’re using Excel on Windows, you can also use the Chart Elements icon on the right of the chart. Check the box for Axis Titles, click the arrow to the right, then check the boxes for the horizontal, vertical, or both titles. When the axis title you select appears on the chart, it has a default name of Axis Title.

How do I graph a lot of data in Excel?

Create a chart

  1. Select the data for which you want to create a chart.
  2. Click INSERT > Recommended Charts.
  3. On the Recommended Charts tab, scroll through the list of charts that Excel recommends for your data, and click any chart to see how your data will look.
  4. When you find the chart you like, click it > OK.

How do you add multiple data to a graph in Excel?

Below are steps you can use to help add two sets of data to a graph in Excel:

  1. Enter data in the Excel spreadsheet you want on the graph.
  2. Select the data you want on the graph.
  3. Click the “Insert” tab and then look at the “Recommended Charts” in the charts group.
  4. Choose “All Charts” and click “Combo” as the chart type.