Q&A for How to Create a Graph in Excel

Click "Edit" and then press "Move." If this doesn't work, double click the axis and use the dots to move it.

Type control p on your laptop or go to print on the page font of your screen?

Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.

Right-click the chart with the data series you want to rename, and click Select Data. In the Select Data Source dialog box, under Legend Entries (Series), select the data series, and click Edit. In the Series name box, type the name you want to use.

In a chart, click the value axis that you want to change, or do the following to select the axis from a list of chart elements: Click anywhere in the chart. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Vertical (Value) Axis.

Assuming you already know how to make a basic bar graph from a workbook? If not, check out Wikihow's article "Create a Graph in Excel." Keep in mind, Column A is used for your horizontal axis information. B1, C1, D1 etc. can be used as headings for each vertical axis. Input information from cell 2 onwards in each column. Just make sure any information you input into these columns correlate cell by cell with your column A horizontal axis information. The information inputted in these columns i.e. B, C, D, E, etc. will be converted into a bar in your bar graph when you select all your information, click "insert", then "chart" and choose bar graph.

To change a data series, you would select a range of your spreadsheet appropriate for the data.

Click on the chart and go to chart design. You will get some options such as white to black. To change the color of bars, simply click on a bar. All bars will automaticly get selected. Go to format and change the color.

You can use a stacked bar chart or a pie chart to show the sexes. Select the desired columns by holding the Shift key for multiple selections, click "Insert" at the top, then "Recommended Charts" in the ribbon. If none of the charts work, click the "All Charts" tab in the chart pop-up window and select your desired chart type and sub-type.

To print in Excel, select the area you want to print and press "Ctrl" + "P" to open the print tab. For saving, use "Ctrl" + "S". For copying and pasting, use "Ctrl" + "C" to copy selected material and "Ctrl" + "V" to paste.

To label the axes, select the chart to make it active, then click the "+" icon at the upper-right corner, which is the "Chart Elements" button. Check the boxes for "Axis Titles," choosing both "Primary Horizontal Axis Title" for the x-axis and "Primary Vertical Axis Title" for the y-axis. You can then click on the placeholders that appear to edit and type in your desired labels.

Insert a graph, then click on "Select Data." Under "Legend Entries," click "Add" and select your first data set. Click "OK" and repeat for each additional set. Once finished, click "OK" to update the graph with all the data sets.

To add a chart title, select the chart and go to the Design tab in the toolbar. Click on the Chart Elements icon to open a drop-down menu, choose Chart Title, and select the position for your title. Then, click inside the title box to enter your desired name.

Go to the "Insert" tab and select the "Shapes" icon. There, you can find arrows that you can place onto the graph.

1. Set up your data. Usually, a line graph requires two axes, so your table should contain at least two columns of data for one line graph. 2. Select the data to be included in the chart. Highlight all the columns and rows of data you want to include in your graph. 3. Insert a line graph. With the source data selected, go to the INSERT tab on the upper right-hand side of the Excel screen, select the line graph icon beside the recommended charts icon, and choose which graph type you prefer.