How do I create a graph chart in Excel?

How do I create a graph chart 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 make Excel graphs look cool?

How to Make Your Excel Line Chart Look Better

  1. Remove Chartjunk – gridlines, chart border, and legend.
  2. Use Soft Gray Lines for the Axes.
  3. Make the Line Wider.
  4. Use a Non-Default Line Color.
  5. Add an Appropriate Title.
  6. Add Data Labels.
  7. IF Specific Data Points are More Important: Emphasize the Line’s Data Points.

How do you plot XY points in Excel?

Go to the “Insert” tab and look for the “Charts” section. In Excel 2007 and earlier versions, click on “Scatter” and choose one of the options that appear in the drop-down menu. In Excel 2010 and later, look for the icon with dots plotted in the xy plane that says “Insert Scatter (X, Y) or Bubble Chart.”

How do I make a graph from sheets?

How to make a graph or chart in Google Sheets

  1. Select cells.
  2. Click Insert.
  3. Select Chart.
  4. Select which kind of chart.
  5. Click Chart Types for options including switching what appears in the rows and columns or other kinds of graphs.
  6. Click Customization for additional formatting options.
  7. Click Insert.

How do I create a chart with multiple data in Excel?

To create a combo chart, select the data you want displayed, then click the dialog launcher in the corner of the Charts group on the Insert tab to open the Insert Chart dialog box. Select combo from the All Charts tab. Select the chart type you want for each data series from the dropdown options.

How do you make a line graph look professional?

7 steps to make a professional looking line graph in Excel or…

  1. Replace the legend with direct labels.
  2. Remove gridlines or make them lighter.
  3. Clean up the axes.
  4. Consider selective data labels.
  5. Add text that explains the message.
  6. Increase font sizes so they are easy to read.
  7. Use color to focus attention.

How can I make my graph look better?

  1. Tip # 1: Always pick the right chart type. Before you start tweaking design elements, you need to make sure that your data is displayed in the optimal format.
  2. Tip # 2: Remove unnecessary axes.
  3. Tip # 3: Distribute bars evenly.
  4. Tip # 4: Remove background lines.
  5. Tip # 5: Remove unnecessary styling.