I made an excel line chart for church attendance on Sunday morning, Sunday night, and Thursday night. The markers are there to show the attendance, but there are no connecting lines even though I chose line chart. I have made a line chart before and it did have the lines. Does anyone know why the lines are not there and how I can add the lines to this chart?

I did not choose scatter chart, so I'm not sure what is going on?

SHAVED

Hi,
Check the chart style. Are you using the XY (Scatter) without lines or you are using the Line Chart with lines?

SHAVED

Hi,
I got you now. Here you go. Right Click the markers > Format Data Series. You will get the window for Formating Data Series. There are two sides. One for the Marker and the left one for Lines. I think you might have checked "None". Select Automatic and click OK. Then the lines will appear. Do the same for each series.

Shawnee

I don't know how to respond to you. Last time I clicked Comment on this Post but this time it won't let me use that...says I have to spread it around so I clicked Answer this Question. Maybe that's what I was supposed to do anyway?

Anyway, I did follow the instruction in your email, but found that automatic was already selected for line and marker so it's not that. If you have any other ideas I sure appreciate it!

SHAVED

Hi,
Dont click the "Comment on this post" unless my post helps you to solve the problem. In your case I think it must be something related to the program itself. I have told what I normally check in such cases but your case seems different. Will keep you posted.

Shawnee

Okay, thanks for all your help!