Certain worksheets or charts may look much better if you change their orientation. So in today's how-to article we'll have a look at how to rotate Excel table or chart. This mainly affects the layout of the printed page, then you will also have a chance to see how to select paper size before printing.
Excel charts help to make sense of your data. You can create line, pie and bar charts by selecting columns of data or using Excel's built-in tools. If you see that they look better rotated from portrait to landscape, you can do this in a couple of clicks.
- Click on the chart to see Chart Tools on the Ribbon.
- Select the Format tab.
- Go to the Chart Elements drop down list and pick Vertical (Value) Axis.
- Click the Format Selection button to see the Format Axis window.
- On the Format Axis window tick the Values in reverse order checkbox.
Change the spreadsheet orientation
Some worksheets are wider than they are tall, so you may find that printouts look better if you switch the orientation from the portrait mode to the landscape one.
You can find the Orientation button on the Page Layout tab of the ribbon. Click the button to get a drop-down menu and select between the Portrait and Landscape options.
Selecting a paper size
Want to know how to tell Excel which size paper you need? Just click the Size button on the Page Layout tab, and select the desired size from the resulting drop-down list.
Hope you'll find this tip helpful. Have a nice day!
- Microsoft Excel Charts: tips, tricks and techniques
- Merge Excel worksheets
- Group data in an Excel PivotTable