How to Make a Graph in Excel

  1. Enter your data into Excel.
  2. Choose one of nine graph and chart options to make.
  3. Highlight your data and click ‘Insert’ your desired graph.
  4. Switch the data on each axis, if necessary.
  5. Adjust your data’s layout and colors.
  6. Change the size of your chart’s legend and axis labels.

How do you create a chart on a separate worksheet in Excel?

To insert a chart:

  1. Select the cells you want to chart, including the column titles and row labels. These cells will be the source data for the chart.
  2. From the Insert tab, click the desired Chart command.
  3. Choose the desired chart type from the drop-down menu.
  4. The selected chart will be inserted in the worksheet.

How do you plot a graph?

Follow these simple steps:

  1. First, find the value for x on the x-axis.
  2. Next, find the y-value – in this case, y=1100, so find 1100 on the y-axis.
  3. Your point should be plotted at the intersection of x=0 and y=1100.
  4. Finally, plot the point on your graph at the appropriate spot.

How do you plot a graph on XY?

Plotting Points on a Graph Cartesian points are written as xy pairs in parentheses, like so: (x, y). To graph a point, first locate its position on the x-axis, then find its location on the y-axis, and finally plot where these meet.

How do you arrange data in a graph?

Select the chart. On the Chart Design tab, select Select Data. Select Switch Row/Column….Tips for arranging data for charts

  1. Select your data.
  2. On the Home tab, select Copy .
  3. Click where you want the new transposed data to be.
  4. Press CONTROL + OPTION + V.
  5. Select Transpose, and then click OK.

How do I arrange scattered data in Excel?

How to Sort in Excel

  1. Highlight the rows and/or columns you want sorted.
  2. Navigate to “Data” along the top and select “Sort.”
  3. If sorting by column, select the column you want to order your sheet by.
  4. If sorting by row, click “Options” and select “Sort left to right.”
  5. Choose what you’d like sorted.

How do you make a chart fill the entire page in Excel?

Shrink a worksheet to fit on one page

  1. Click Page Layout.
  2. Select the Page tab in the Page Setup dialog box.
  3. Select Fit to under Scaling.
  4. To fit your document to print on one page, choose 1 page(s) wide by 1 tall in the Fit to boxes.
  5. Press OK at the bottom of the Page Setup dialog box.

How do you create a graph in Excel?

1) Select data for the chart. 2) Select Insert > Recommended Charts . 3) Select a chart on the Recommended Charts tab, to preview the chart. 4) Select a chart. 5) Select OK . See More…

How to make a graph in Excel?

Highlight the cells that contain the data you want to use in your graph by clicking and dragging your mouse across the cells.

  • Your cell range will now be highlighted in gray.
  • Once the text is highlighted you can select a graph (which Excel refers to as chart). Click the Insert tab and click Recommended Charts on the toolbar.

    • How to make a chart or graph in Excel [with video tutorial]?

    Select Chart Type Once your data is highlighted in the Workbook,click the Insert tab on the top banner.

  • Create Your Chart From the Insert tab,click the column chart icon and select Clustered Column.
  • Add Chart Elements Adding chart elements to your chart or graph will enhance it by clarifying data or providing additional context.
  • Adjust Quick Layout The second dropdown menu on the toolbar is Quick Layout,which allows you to quickly change the layout of elements in your chart (titles,legend,…
  • Change Colors The next dropdown menu in the toolbar is Change Colors.
  • Change Style For cluster column charts,there are 14 chart styles available.
  • Switch Row/Column Click the Switch Row/Column on the toolbar to flip the axes.
  • Select Data Click the Select Data icon on the toolbar to change the range of your data. A window will open.
  • Change Chart Type Click the Change Chart Type dropdown menu. Here you can change your chart type to any of the nine chart categories that Excel offers.
  • Move Chart Click the Move Chart icon on the far right of the toolbar. A dialogue box appears where you can choose where to place your chart.
  • Change Formatting The Format tab allows you to change formatting of all elements and text in the chart,including colors,size,shape,fill,and alignment,and the ability
  • Delete a Chart

    • How to make a scatter plot in Excel?

    Select two columns with numeric data, including the column headers. In our case, it is the range C1:D13. Do not select any other columns to avoid

  • Go to the Inset tab > Chats group, click the Scatter chart icon, and select the desired template. To insert a classic scatter graph, click the first