Is there a maximum number of columns available to put into a line graph?

**Luch** · 09-17-2012, 04:54 PM

What I am trying to do I didnt think would be that hard, but I am trying it in Excell and numbers for Mac and I am getting the same result. I took 23 different sound meter readings from around a site. For each point there are 11 different DB readings for each of the different sound octaves. all I want to do is plot all of these on a line graph to compare them against what the local noise ordinance is. But every time I get over 10 points of data, it changes the outlook of the whole graph, changes my axis all around and I dont understand it. Please help. Attached is the file as well as a JPEG screenshot to help explain. Thanks

**Jacc** · 09-17-2012, 05:39 PM

I don't know why Excel decides to switch rows and columns at some point but you can just switch it back.Servercool data Switch Row and Column.jpg

**FDibbins** · 09-17-2012, 05:57 PM

i am using 2003, so this may be different for you. i rt clicked into the graph, selected "source data" and then checked "series in columns"

see attached

**Luch** · 09-17-2012, 07:34 PM

The data is there now but it is still doing something weird. On the left side or Y-axis, the range went from 0-60 to 0-1200. The data lines should be more random and overlap (as in my first screenshot) rather than mirror each other and not touch. I cant figure out why its doing this when you add on another column of data.

**FDibbins** · 09-17-2012, 08:21 PM

that is weird, because in my file on my screen, it follows exactly the same pattern as your 1st graph with only 9 points.

see attached file, it contains a screenshot of the graph as well as the graph.

let me know if they are different?

**Luch** · 09-17-2012, 08:39 PM

Yes. It is strange. Both of your replies with your files when I open them look like this...

The scale on the left is wrong. If you hover over the individual points on the graph, it will tell you the value, but for some reason it doesn't correspond to the value listed on the Y-axis. Doesnt make any sense.

**FDibbins** · 09-17-2012, 08:50 PM

ok, i think i have found your problem. you have the graph set as a stacked line. change it to a regular line graph

let me know if that fixes it?

**Luch** · 09-17-2012, 11:19 PM

Originally Posted by Jacc

I don't know why Excel decides to switch rows and columns at some point but you can just switch it back.Attachment 181093

This fixed it! Thanks a lot!

**FDibbins** · 09-17-2012, 11:43 PM

glad to help. it would be appreciated if you would thank those who helped you by clicking on the star on the lower left of the post
also, if this solved your question, could you please mark it as solved...it helps keep things neat and tidy

(see points 2 and 3 below)

**Cutter** · 09-18-2012, 12:52 PM

@ Luch

Welcome to the forum.

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.