How to Make Excel Data Horizontal. ... it can lead to errors to try to retype or drag cell data individually into a horizontal or row format. ... How to Create a Clear Graph.

Excel can also create a graph to show you year-over-year changes as long as you have your data broken down into periods shorter than a year. Graph by Year Open a new Excel 2010 spreadsheet.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.