Chart & Visualization Issues

How to Rotate or Change the Orientation of an Excel Chart

Rana Garcia Sep 27, 2026 870 views

Question details

The user wants to learn how to physically rotate an Excel chart or alter its data orientation.

How to Rotate or Change the Orientation of an Excel Chart

Product: Spreadsheets
Device & OS: not provided
Scenario: Customizing the layout and visual presentation of a chart within a spreadsheet.
Observed behavior: Excel does not have a single universal rotate command for all charts. Changing the physical angle of the chart requires a different method than swapping the axes of the data.

Before you start

Determine whether you need to physically spin the chart's visual appearance on the page, or if you want to flip the data itself by swapping the horizontal and vertical axes.

Solution 1Recommended

Rotate the Chart as a Picture

Use this method if you need to physically spin the chart's visual layout on the page, such as turning it 90 degrees.

Standard Excel charts cannot be rotated freely while they are active data objects. To rotate the entire chart container, you must convert it into an image first.

Select and Copy

Click on the outer edge of your existing chart to select it, then press Ctrl+C or right-click and choose Copy.

Paste as a Picture

Right-click on an empty cell in your spreadsheet. Under the Paste Options, click the 'Picture' icon (Paste as Picture).

Rotate the Picture

Select the newly pasted picture. Go to the Picture Format tab on the top ribbon, click the Rotate button, and select your desired rotation angle (e.g., Rotate Right 90°).

Data Connection Lost: Once the chart is pasted as a picture, it becomes a static image. It will no longer update automatically if you change the original data.

Solution 2

Change Chart Orientation by Swapping Axes or Type

Use this method to change how the data is plotted, such as switching from a vertical column chart to a horizontal bar chart.

Effortless Data Visualization

Easily Create and Format Charts with WPS Office

WPS Office Spreadsheet provides intuitive tools for building, customizing, and formatting charts. You can effortlessly switch data axes, change chart orientations, or export your charts as images while enjoying full Microsoft Excel compatibility.

1. Insert a Chart: Highlight your dataset in WPS Spreadsheet, go to the Insert tab, and choose your preferred chart type.
2. Adjust Data Orientation: Click the chart to reveal Chart Tools. Click the 'Switch Row/Column' button to instantly swap how your data is plotted.
3. Save as Picture to Rotate: To freely rotate the chart's appearance, right-click the chart border and select 'Save as Picture'. You can then insert this image and rotate it using the standard image rotation handle.

Fully compatible with Microsoft Excel (.xlsx) chart formatsIntuitive drag-and-drop formatting for quick visual adjustmentsEasily save active charts as high-quality pictures with one clickFree to use with a lightweight, user-friendly interface

microsoft office alternative - wps office

Frequently Asked Questions

Can I rotate a 3D chart in Excel?

Yes, you can rotate 3D charts. Right-click the chart area, select '3D Rotation', and adjust the X and Y rotation degrees in the Format Chart Area pane.

Why is the Switch Row/Column button grayed out?

This button may be disabled if you are actively typing inside a cell, if the chart itself is not selected, or if the chart type does not support axis swapping (such as a pie chart with only one data series).

How do I rotate the text on the axis of a chart?

Right-click the axis labels and select 'Format Axis'. In the formatting pane, go to the Size & Properties icon, then select your desired text direction or type a custom angle degree.

Does WPS Office support the same chart types as Microsoft Excel?

Yes, WPS Office Spreadsheet supports the vast majority of standard chart types found in Excel, including column, line, pie, bar, area, and scatter charts, ensuring your visualizations remain intact when sharing files.

Excel & Data Problems