Quick Answer: How Do You Use Excel To Make A Graph?

How do you make an XY graph in Excel?

Create a scatter chartSelect the data you want to plot in the chart.Click the Insert tab, and then click X Y Scatter, and under Scatter, pick a chart.With the chart selected, click the Chart Design tab to do any of the following:More items….

How do I create a bar graph in Excel with two variables?

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.

What is the best program to make graphs?

The Best Software for Making Graphs & ChartsUser-Friendly Options: Excel and Pages. Microsoft Excel and Apple Pages are two popular charting and graphing programs used by college students and teachers in universities, generally because they are user-friendly. … Origin Lab. … Adobe Illustrator.

How do I make a graph from an Excel spreadsheet?

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

How do I make a good graph in Excel?

TL;DRPick the right graph. Use the right tool for the job.Sort your data; don’t leave it for Excel to decide where your data will appear.Adjust your axis. Keep your number formats and category titles clean.Check your margins. … Remove unnecessary styling. … Pick your colors. … Format your legend. … Choose your title.

What are the types of chart in Excel?

Available chart types in OfficeColumn chart. Data that’s arranged in columns or rows on a worksheet can be plotted in a column chart. … Line chart. Data that’s arranged in columns or rows on a worksheet can be plotted in a line chart. … Bar chart. … Area chart. … Stock chart. … Surface chart. … Radar charts. … Treemap chart (Office 2016 and newer versions only)More items…

Where is Chart Wizard in Excel?

You can display the chart wizard by either selecting (Insert > Chart) or by pressing the chart wizard button on the standard toolbar. The chart wizard is a series of dialog boxes which lets you make decisions regarding the chart you want to create.

How do I make a bar graph?

Steps in the ProcessDecide on a title for your graph (Pet Popularity).Draw the vertical and horizontal axes.Label the horizontal axes (Type of Pet).Write the names of pets where the bars will be (Parakeet, Dog, and so on).Label the vertical axes (Number of Students).Decide on the scale.More items…

How do I make a simple line graph in Excel?

Create a line chartCopy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot into a line chart. … Select the data that you want to plot in the line chart.Click the Insert tab, and then click Insert Line or Area Chart.Click Line with Markers.More items…

How do you create a chart?

Create a chartSelect data for the chart.Select Insert > Recommended Charts.Select a chart on the Recommended Charts tab, to preview the chart. Note: You can select the data you want in the chart and press ALT + F1 to create a chart immediately, but it might not be the best chart for the data. … Select a chart.Select OK.