Q&A for How to Make a Line Graph in Microsoft Excel

Return to Full Article

Coming soon

Add New Question

Question

How do I name the y and X axis in the graph?

Community Answer

1. Click on the graph. 2. Select 'Chart Elements' on the side, which is the plus icon. 3. Tick the 'Axis Titles' box. Some text boxes should appear on the x and y 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 47 Helpful 33
Question

If multiple lines are present in my chart, how can I view one at a time?

Community Answer

One method is to hide the relevant rows or columns that you do not wish to show on the graph. Hidden rows and columns are not displayed.

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 37 Helpful 21
Question

Why do my years show up as numbers?

Community Answer

Because A,B,C,D,E, and F, mean this: (A:2000->B:2001->C:2002->D:2003->E:2004->F:2005.)

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 104 Helpful 38
Question

How can I add a line to represent my target or goal?

Community Answer

Add another column to the right and for each cell, just add the goal number. This will add another line to your chart for that target number or set of numbers.

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 31 Helpful 14
Question

Can axis scales be customized rather than automatic?

Community Answer

Yes. Right click on the axis that you want to change and select "format axis". This opens a window with all the axis options available to you. Just click on whichever variable it is you do not want to be automatic and put in the values that you want.

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 20 Helpful 4
Question

How do I make a line graph?

Community Answer

Highlight the data you want, go on the insert bar and then click the line graph icon.

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 10 Helpful 3