I need help with creating a line chart in excel. Here's what I have tried so far: I have created a table in excel and selected the data to use for...

How It Works

Get an answer in three easy steps. Here's how it works...

Ask Your Question

1. Ask Your Question

Enter your Microsoft Excel question at the top of this page and click Get An Answer.

Pick Your Priority

2. Pick Your Priority

Tell us how quickly you want your Microsoft Excel question answered.

Get An Answer

3. Get An Answer

Connect with your Microsoft Excel tech via online chat or telephone call.

Answer

Customer

I need help with creating a line chart in excel.

Here's what I have tried so far:
I have created a table in excel and selected the data to use for the chart. I have selected the chart. My Y axis data is from 15 to -15 with 0 being my base line. My X data is each day of the month but it is showing on 0 in the middle of the graph in 5 day increments starting with 05/26/2015 - 07/5/2015. My table data is only for the month of June.

Here's my brand/make/model:

Last updated
Bobby Hicks
Microsoft Excel Tech

Hello and welcome to Experthelp! My name is Bobby and I will do my best to help you.

Last updated
Bobby Hicks
Microsoft Excel Tech

I’m available to chat now. I’ll leave my chat session open for the next 15 minutes or so and wait for you to join. If I don’t catch you this time, please reply with a few times that work best for you and we can connect one of those times.

Posted
Bobby Hicks
Microsoft Excel Tech

Chatted with the customer and noticed that he was having a horizontal axis with the wrong dates. He wanted only the month of June. So I edited the horizontal axis to show the right day by typing it in the minimum column 6/1/2015 and in the maximum 6/30/15 which solved his issue with the months. To get it to show each day you have to edit how many units by changing the major to 1 which means one day and the minor will automatically change to .02.

Posted
Bobby Hicks
Microsoft Excel Tech

Hello Jay

I got your email earlier today, and I sent you a link on how to do what you want to do, Did it help you or do you still need assistance?

Posted
Bobby Hicks
Microsoft Excel Tech

Customer asked about a line graph within a bar graph, I sent him a link to the page that can help him, which it did.

Posted
Bobby Hicks
Microsoft Excel Tech

Hello Jay,

I am doing a follow up with you, do you still need help? If so I am here to help.

Posted
Bobby Hicks
Microsoft Excel Tech

Called customer today to see if he still need assistance, but no answer, left a message with the customer.

Posted

quoteTestimonialsquote

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

More Microsoft Excel Questions...

Ask Your Microsoft Excel Question & Get An Answer Now!