Some pages or graphics look much better if you change their orientation. In this article, we will look at how to rotate a table or graph in Excel. This mainly affects the page layout for printing. And at the very end of the article you will learn how to choose the paper size before printing.
Rotate a chart in Excel
Graphs in Excel make information more understandable. You can create a line chart, pie chart or bar chart by selecting data columns or by using Excel’s built-in tools. If you decide that the diagram will look better when we change its orientation, you can do it with a couple of mouse clicks.
Translator’s Note: The technique that the author demonstrates does not turn the chart orientation from landscape to portrait, but only changes the direction of one of the axes: it was from bottom to top, but it will be from top to bottom.
- Click on the chart to display the tab group on the Ribbon Chart Tools (Working with diagrams).
- Click the tab Size (Format).
- Open the dropdown Chart Elements (Chart Elements) and select Vertical (Value) Axis (Vertical axis(values)).
- Нажмите кнопку Format Selection (Format Selection) to open the dialog box Format Axis (Axis format).
- In the dialog box Format Axis (Axis Format) check the box next to Values in reverse order (Reverse order of values).
Changing page orientation
It happens that the table is wider than it is tall. I am sure you will agree that such a table will look better in print if you change the orientation of the printed page from portrait to landscape.
The team Orientation (Orientation) You will find on the tab Page Layout (Page layout). Click on it to open the drop-down menu and select one of the options: Portrait (Book) or Landscape (Album).
For some Excel documents, changing the orientation from portrait to landscape can significantly reduce the total number of pages. So try experimenting with the settings and then decide which one works best.
Choosing a paper size
Wondering how to tell Excel what paper size you need? To do this, just press the button Size (Size) tab Page Layout (Page layout) and select the desired size from the drop-down list.
I hope these tips are helpful to you. I wish you a good day!