How do I add a second Y axis in Excel 2007?

Add or remove a secondary axis in a chart in Excel

1. Select a chart to open Chart Tools.
2. Select Design > Change Chart Type.
3. Select Combo > Cluster Column – Line on Secondary Axis.
4. Select Secondary Axis for the data series you want to show.
5. Select the drop-down arrow and choose Line.
6. Select OK.

How do you superscript in Excel 2007?

While your mouse is over the selected text, right-click and then select “Format Cells” from the popup menu. When the Format Cells window appears, select the Font tab. Check the Superscript checkbox. Now when you return to your spreadsheet, you should see the selected text as a superscript value.

How do I ungroup in Excel 2007?

To ungroup grouped sheets, click a sheet tab outside of the group, or right-click any of the grouped tabs and choose Ungroup Sheets from the shortcut menu.

Can you have more than 2 axis in Excel?

Yes, in Excel 2013 and Excel 2016 you can have two axes. Start by creating a chart with just one axis. Select the data series you wish to place on a secondary axis, by clicking on the series in the chart.

How do you add two sets of data in Excel?

Use Excel’s chart wizard to make a combo chart that combines two chart types, each with its own data set.

1. Select the two sets of data you want to use to create the graph.
2. Choose the “Insert” tab, and then select “Recommended Charts” in the Charts group.

How do you do subscript and superscript in Excel 2007?

Press CTRL+1. Under Effects, check the Superscript or Subscript box, and click OK. Tip: Although Excel doesn’t have quick keyboard shortcuts to these commands, you can navigate the menus and dialogs with just the keyboard. Use Alt+HFNE for superscript, and Alt+HFNB for subscript.

Why can’t I ungroup in Excel?

Right-click on the tab for one of the grouped sheets, choose Select All Sheets, then Ungroup Sheets. The [Group] indicator disappears in the title bar, as expected.

What is grouping and ungrouping in Excel?

The “group” is an Excel tool which groups two or more rows or columns. The Excel shortcut “Shift+Alt+Right Arrow” groups data and “Shift+Alt+Left Arrow” ungroups data. The “clear outline” option removes grouping from the worksheet.

How do I write math equations in Excel 2007?

Insert an equation with Equation Editor

1. On the Insert tab, in the Text group, click Object.
2. In the Object dialog box, click the Create New tab.
3. In the Object type box, click Microsoft Equation 3.0, and then click OK.
4. Use the symbols, templates, or frameworks on the Equation toolbar to edit the equation.