Q&A for How to Create a Graph in Excel

Return to Full Article

Coming soon

Add New Question

Question

How do I change the horizontal axis to a vertical axis in Excel?

Community Answer

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

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 38 Helpful 12
Question

How do I print a graph only in Excel?

Community Answer

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

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 8 Helpful 12
Question

How do I label a Series?

Jayna Akanova

Community Answer

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 8 Helpful 6
Question

How to rename data series?

Jayna Akanova

Community Answer

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 3
Question

How can I change the range of numbers in the vertical axis?

Jayna Akanova

Community Answer

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 4 Helpful 4
Question

How can I add another vertical axis in a graph?

Deborah Archary

Community Answer

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 3 Helpful 4
Question

How do I change a data series?

Tina X

Community Answer

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

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 2 Helpful 2
Question

How do I change the color on my bar graph?

Ahhna Shrivstava

Community Answer

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.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 4