In the Data section, locate and click on the Switch Row/Column button to have Excel. changing the column headings in the sheet or editing the chart directly in new. You should now see three new tabs in Excel Design, Layout, and Format. A tutorial applicable for all versions of Excel - 2010, 2007, 2003, 2000. You can find the Orientation button on the Page Layout tab of the ribbon. To try and switch the axes of a scatter chart using this method, you need to: Click anywhere on the scatter chart you watch to switch the axes to select it. Step 4: Add the axis titles, increase the size of the bubble and Change the chart title as we have discussed in the above example. Step 3: This will create the scatter diagram. 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. Step 2: Go to Insert > Chart > Scatter Chart > Click on the first chart. On the Format Axis window tick the Values in reverse order checkbox.Click the Format Selection button to see the Format Axis window.Go to the Chart Elements drop down list and pick Vertical (Value) Axis.Click on the chart to see Chart Tools on the Ribbon.If you see that they look better rotated from portrait to landscape, you can do this in a couple of clicks. You can create line, pie and bar charts by selecting columns of data or using Excel's built-in tools.
#How to change axes of a scatter chart in excel 2007 how to#
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.Įxcel charts help to make sense of your data. So in today's how-to article we'll have a look at how to rotate Excel table or chart. Certain worksheets or charts may look much better if you change their orientation.