As the title states, I'm having trouble with excel not putting data into the line graph the way I want it to. Ssh0GAJ.png
Here's a screenshot of my issue. My prof didn't give detailed instructions on how to format the data so I'm not sure what to do to get it into a singular line graph instead of one "line" for each year.
Cheers!
So you want time line graph, with one continuous line going from Jan 2008 to Jan 2018?
Then just reorganize your data to flat table structre (i.e. date column and value column) and chart. Instead of having it in cross-tab structure.
?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
― Robert A. Heinlein
Is there a way to automatically do this or will I have to do it manually?
Nevermind, found out how to get the data from the site in the format I needed it in.
Thanks for helping and have a good day
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks