Question: How Do I Convert Excel To Graph?

How do you make a bar graph in Excel with two sets of data?

Use Excel’s chart wizard to make a combo chart that combines two chart types, each with its own data set.Select the two sets of data you want to use to create the graph.Choose the “Insert” tab, and then select “Recommended Charts” in the Charts group.More items….

How do I turn an Excel spreadsheet into a bar graph?

Open Excel. … Select all the data that you want included in the bar chart. … Click the Chart Wizard toolbar button, or choose Chart from the Insert menu.Make sure that Column is selected under Chart type (it’s the default setting).Select a subtype of bar graph from the display on the right, and click Next.More items…•

How do I use Excel to make 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.

How do I convert Excel data to a line graph?

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 make a graph on Excel without data?

From ScratchStart Word. Click the “Insert” tab, and then click the “Chart” button. … Click the “Chart Type” drop-down menu and choose “Line Chart.”Click into the small Excel window on the page. Highlight all of the cells.Press the “Delete” key to remove all of the data, making the chart empty.

How do I make lines in Excel?

Follow these steps to add cell borders:Select the cells you want to format.Click the down arrow beside the Borders button in the Font group on the Home tab. A drop-down menu appears, with all the border options you can apply to the cell selection. … Click the type of line you want to apply to the selected cells.

How do I make a text data graph in Excel?

Select the “Insert” tab in the Ribbon at the top of the page. Click the drop-down box for the “Column,” “Pie” or “Bar” chart type. These chart types allow number and word variables, where Line charts, Scatter charts, and Area charts require two numeric variables.

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.