Excel 2013 - Converting chart into line graph

Hello,

I have created a chart in Excel which is more like a bar graph. Each element has a bar whose length corresponds to the value of the cell. I need to convert it to a line graph (I hope I'm using the right terminology.)  By LINE GRAPH, I mean what we used to do back in match class, plotting a series of data points, then connecting each point with a line.

I tried going into CHANGE CHART TYPE, but the closest I can find is a scattered X, Y graph that contains the data points only. (Please see screenshot at the bottom of this post.)

Is there a choice that I'm overlooking that can generate the graph that I need?

Thanks,
Steve

Change Chart Type Screen
LVL 4
Stephen KairysTechnical Writer - ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

SANTABABYSoftware ProfessionalCommented:
Do you see any option for Line chart (picture attached) ?
Also, please see the following link:
http://spreadsheets.about.com/od/excelcharts/ss/90209linegraph.htm
LineChart.jpg
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Santababy,

OK, I tried that (the option is LINE not LINE CHART but that's OK) but my chart is now totally blank when there are definitely data values there. Thanks.
0
SANTABABYSoftware ProfessionalCommented:
Please RMB on the chart and choose Select Data and select the range from your worksheet that contains data.
Note: I'm using Excel 2010, so the names and choices may look different for Excel 2003.
0
Bootstrap 4: Exploring New Features

Learn how to use and navigate the new features included in Bootstrap 4, the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first websites.

Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Sorry, what's RMB?

I tried selecting the data, but once the chart displayed, the column looked like it was no longer selected...I'm assuming by select-the-data, you mean highlight the entire column?

Thanks.
0
SANTABABYSoftware ProfessionalCommented:
Sorry for using the shortcut, it is :Right Mouse Button.
Basically I requested you to basically select the entire range which has the data that you want to associate with the chart.
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
No problem. So I now have selected the data range (Column I). The chart (sort of looks like a bar graph) is now displaying.  Where do I go next to convert to a line graph? Thank you again.
0
SANTABABYSoftware ProfessionalCommented:
I found a machine that runs excel 2003 and this is what I found.

To change a bar style chart:
Click Right Mouse button on the chart
Select chart type
From the Left pane, select "Line"
Then select the subtype of your choice from the right pane.
Click ok and you should be done.

Good Luck.
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thanks.
Unfortunately, though, none of the subtypes draw the type of graph I need.  e.g. I get a blank graph, something that looks like a bar graph, a bunch of dots WITHOUT the connecting lines....
0
SANTABABYSoftware ProfessionalCommented:
if you want, please attach the file with data. I can give it a try.
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thanks for the offer. However, it's a file of personal info that I cannot share...any other ideas?

Thanks again.
Steve
0
SANTABABYSoftware ProfessionalCommented:
No problem. I understand. To move forward you may want to try one of the following:
1. Visit the link that I provided above
If the info does not help much,
2. Create some mock data and attach to your post.
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
OK. I just tried to isolate the problem...drawing on my background as a Software Developer. :) .. this is starting to be fun. :)

My data is a bit complex - for lack of a better word - because
1. Many of the values are not whole numbers.
2. The column is sparse...only 34 of the apx. 220 rows have info.

So, I created a new test spreadsheet with three columns
A. All whole numbers - all rows have values. The first format for the line chart comes out fine.
B. All non-whole numbers- all rows have values. The first format for the line chart comes out fine.
C. All whole numbers, only some rows have values. The format come out blank.
D. All non-whole numbers, only some rows have values. The format comes out blank.

I have pasted the pulldown screen with the graph type circled below.
Excel Graph - Isolate Problem
So, I think I'm getting somewhere....any thoughts?

Thanks,
Steve
0
Rory ArchibaldCommented:
If you already have a bar chart, you should only have to change the chart type, or right-click a series, choose 'change series chart type' and then choose Line. The data will remain the same.

If you can get XY scatter to plot correctly per your first graphic, you can simply choose one of the options that adds lines to the markers.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
SantaBaby and Rory:

I am attaching the spreadsheet. Per Column C. You'll see that the scatter plot works but changing to line graph does not. Thanks.

Steve
GraphTest.xlsx
0
Rory ArchibaldCommented:
It does work, it's just that the gaps in your data cause no lines to appear by default (you'd see markers if you used a line chart with markers). In the Select Data dialog, click the Hidden and Empty cells button, then choose 'Connect data points with line'.
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Thanks, Rory. That seems to have worked.

I'll review your answers and SantaBaby, I'll do the same for yours so that I can assign points. Hope to do so later today.

Steve
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Rory,

OK. So I was sitting at the top of the worksheet and went through the steps to create my chart. When I choose SELECT DATA, the worksheet scrolls to the bottom of the page; and to find the chart that's eventually created, I have to scroll back to the top. Is this expected behavior?

Thanks,
Steve
0
Rory ArchibaldCommented:
Is the data at the bottom of the page? If so, then yes that's normal.
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Well, for this column there is sparse (scattered) data in apx. 34 of the apx. 230 rows including the last row....Thanks.
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Hey Rory,
Did you see the above? Thanks. Just want to be sure what I'm seeing is correct. Thanks.

Steve
0
Rory ArchibaldCommented:
Sounds normal to me. :)
0
Stephen KairysTechnical Writer - ConsultantAuthor Commented:
Rory: Thank you. I credited two of your solutions (the second one had the critical info per connecting the dots)

Santababy: Thanks for your efforts to help. Since it seemed that your sol'ns were more per older versions of Excel - I'm on 2013 - I'm afraid I can't give points. Sorry about that..you were pretty close, though.

Steve
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.