Flip The | search
Click here to view Flip The news from 60+ newspapers.
Bookmark or Share- Change the scale of the vertical (value) axis in a chartBy default, Excel determines the minimum and maximum scale values of the vertical (value) axis, also known as the y axis, when you create a chart. However, you can customize the scale to better meet your needs.
- Edit titles or data labels in a chart - Microsoft SupportTo edit the contents of a title, click the chart or axis title that you want to change. To edit the contents of a data label, click two times on the data label that you want to change. The first click selects the data labels for the whole data series, and the second click selects the individual data label.
- Change the plotting order of categories, values, or data seriesTo change the plotting order of categories, click the horizontal (category) axis. To change the plotting order of values, click the vertical (value) axis. Click a chart. This displays the Chart Tools.
- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportHere's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.
- Transpose (rotate) data from rows to columns or vice versaIf you have a worksheet with data in columns that you need to rotate to rearrange it in rows, use the Transpose feature. With it, you can quickly switch data from columns to rows, or vice versa. For example, if your data looks like this, with Sales Regions in the column headings and Quarters along the left side:
More
