Posted: 2/5/2011 12:45:53 PM EDT
|
I am not really computer illiterate, but its not my specialty
I am putting together a presentation on a company for Monday evening and I downloaded this companies financial statements to Excel, and I picked out the rows of data I needed. I pasted these rows into a different worksheet so all of the rows I needed were right on top of each other. What I really want to do is use this data to make a line chart, so I highlight the data and click on graph line chart. Well the chart looks great but it is backwards. The data goes from oldest to newest (right to left respectively). Well the chart is taking the newest data (the data on the farthest left) and starting the chart there, which is backwards. The chart looks great, its just backwards. Any help is really appreciated because I dont want to be doing this on Saturday any longer than I have to. Thanks |
|
Quoted:
Copy the data, go to a new sheet, hit paste special, and check transpose Now that the data's vertical, sort it oldest to newest, copy, paste special, and check transpose to get it horiztonal again. Thanks very much! If I had a job I would buy you a pmag my friend. I really would. |