Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday. Now the horizontal axis crosses the vertical axis at 20,000, making it easier to compare data points and read the chart.Ĭheck out the Microsoft Excel archive, and catch up on other Excel tips. Click the Minimum text box and enter 20000.Right-click the selected vertical axis.Click on Select Data in the resulting context menu. If you can’t find the transpose option under Paste Options, go to Paste Special > Transpose. Paste your table by using Ctrl+V or Cmd+V. Click a value in the chart’s vertical axis to select it. Right-click on either the X-axis of the scatter chart or its Y axis, doesn’t really matter which one. Open Microsoft Excel, and create a new document by selecting Blank Workbook.Open the Excel file containing the chart.Here is a better way to change the automatic axis settings: You can try to make the chart easier to read by resizing and enlarging the chart area, but there will still be a lot of white space at the bottom of the chart. If an Excel chart’s vertical axis is incremented by 20,000, and most of its data points are between 70,000 and 550,000, the chart will look somewhat crowded at the top if the horizontal axis crosses the vertical axis at zero. If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings. Change an Excel chart’s minimum axis value for a cleaner look
0 Comments
Leave a Reply. |