Apr
16

How to rotate Excel charts or worksheets: quick tip

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.

Automate your daily tasks in Excel

Ultimate Suite for Microsoft Excel - a complete set of 20+ smart tools that will automate most of repetitive and error-prone tasks you perform daily:

  • Match and merge data from two worksheets.
  • Remove duplicates in one Excel table or between two lists.
  • Consolidate multiple workbooks into one.
  • Merge cells, columns and rows, combine data from duplicate rows into one.
  • And more.

Special offer only for our blog readers and only until next Friday!

Click to get a license of Ultimate Suite and save $45 off the regular price!

Download Now!
Free 20-day trial version, 32.14 MB

Rotating the Excel chart

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.

  1. Click on the chart to see Chart Tools on the Ribbon.
  2. Select the Format tab.
    Excel chart tools - Select the Format tab
  3. Go to the Chart Elements drop down list and pick Vertical (Value) Axis.
    Excel charts -  Vertical(value) Axis
  4. Click the Format Selection button to see the Format Axis window.
    Click the Format Selection button to see the Format Axis window
  5. On the Format Axis window tick the Values in reverse order checkbox.
    Tick the Values in reverse order checkbox on this window


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.

You can find the Orientation button on the Page Layout tab of the Ribbon

For some Excel documents the total page count can decrease in portrait or landscape mode. So you can play with the settings to see which works better.


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!

See also

4 Responses to "How to rotate Excel charts or worksheets: quick tip"

  1. Louise Allen says:

    Not quite what I was expecting! I was hoping to find out if a chart could rotated in the same way an image can be. I can tweak the orientation and positioning of the text but I need my area/line chart to be orientated the same way as my bar chart for a direct comparison.

  2. Harry says:

    I also was looking for a way to rotate the graph like an image, like Louise.

  3. Jeeson says:

    It is more than a year since we have asked for a solution. No one in Microsoft has cared to respond to our friend’s request.

  4. jazmin says:

    no. no no no no NO. NOT what I was looking for.

Post a comment