• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

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
0
Stephen Kairys
Asked:
Stephen Kairys
  • 12
  • 6
  • 4
2 Solutions
 
SANTABABYCommented:
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
 
SANTABABYCommented:
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
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
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
 
SANTABABYCommented:
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
 
SANTABABYCommented:
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
 
SANTABABYCommented:
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
 
SANTABABYCommented:
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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 12
  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now