In a chart, click the value axis that you want to change, or do the following to select the axis from a list of chart elements: ... On the Format tab, in the Current Selection group, click Format Selection. In the Format Axis dialog box, click Axis Options, and then do one or more of the following:

4 Answers Click somewhere on the chart to select it. You should now see 3 new tabs appear at the top of the screen called " Design", " Layout" and " Format". Click on the " Design" tab. There will be a button called " Switch Row/ Column" within the "data" group, click it.

Set Intervals on a Category Axis. Open the Excel 2010 spreadsheet where your chart is located, then click anywhere on the chart. Click the " Format" tab at the top of the screen. Click the drop-down arrow on the left edge of the Excel ribbon and choose the " Category" axis that you want to change.

Click the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the data series that you want to plot along a secondary vertical axis.

Add axis titles manually Click anywhere in the chart to which you want to add axis titles. ... On the Layout tab, in the Labels group, click Axis Titles. Do any of the following: ... In the Axis Title text box that appears in the chart, type the text that you want. ... To format the text in the title box, do the following:

Change the way that data is plotted Click anywhere in the chart that contains the data series that you want to plot on different axes. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Design tab, in the Data group, click Switch Row/ Column.


Reference cells from other spreadsheets by adding the sheet name, followed by an exclamation point, before the cell reference. Use commas to separate up to 255 cell references in the Sum function. For example, "= SUM( Sheet2! A1, Sheet3! B2: B6)" adds the values in cell A1 of Sheet2 to the values in B3 through B6 of Sheet3.

Type =, then click the cell that contains the first text you want to combine, such as a person's first name. Type &” “& (a space enclosed in quotation marks). Click the next cell with the text that you want to combine, such as the person's last name, then press Enter.

See screenshot: Tip: If you want to count the duplicates in the whole Column, use this formula = COUNTIF( A: A, A2) (the Column A indicates column of data, and A2 stands the cell you want to count the frequency, you can change them as you need).

Start by clicking your mouse in the “ Reference” field within the Function box. Then navigate to the first of the two worksheets containing data you want to consolidate. When you are on that sheet, use your mouse to highlight the desired cells. Click “ Add” in the Function box on your master worksheet.

To create a link to cells in an Excel table Start creating a formula that will include a value from cells in an Excel table. Click the sheet tab of the worksheet with the Excel table that contains the cells you want to include in the formula. Select the cell or cells to include in the formula. Press Enter.


Creating drop down lists with comma-separated values Select a cell or range for your drop-down list. ... Use Excel Data Validation to create a drop-down list. ... Enter the list items and choose the options. ... Type the entries for your drop-down list. ... Create a named range. ... Select the location for your drop-down list.