In Excel 2007/2010, you can choose Secondary Axis from the first screen of the Format Series dialog. In Excel 2003, first choose the Axis tab in the toolbar, then choose Secondary Axis.

How do you make a graph on Excel 2003?

Creating a chart sheet

  1. Create an embedded chart.
  2. Select the chart to be moved to a chart sheet.
  3. Choose Chart Location from the menu bar.
  4. In the Chart Location dialog box, select the As a new sheet button. (The As object in button adds the chart as an embedded object on the worksheet.)
  5. Click the OK button.

How do you make a graph with two y axis?

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 I make a bar graph in Excel 2003?

Choose the Column Chart type and the Chart sub-type in the upper left corner (basic bar graph). This chart type creates a vertical bar graph, which Excel refers to as a Column chart. If you want to create a horizontal bar graph, choose the Bar chart type. Click Next when you are done.

How do you insert a graph in Word 2003?

To insert a chart:

  1. Select Insert from the main menu.
  2. Select Picture. Chart from the cascading menu.
  3. Delete the existing data in the datasheet.
  4. Enter your own data in the datasheet.
  5. Close the datasheet. All of your changes will appear in the chart.
  6. Save and close the document.

How to make a double line graph in Excel?

Open the Excel worksheet that contains the data values.

  • Click and drag on the categories and two data series you want to plot.
  • Click the “Insert” tab in the Command Ribbon.
  • Click the arrow for the “Line” button in the Charts group.
  • Click the preferred chart sub-type.
  • Click “OK.” The two data series convert to a line graph.

    • How to add two axis in Excel?

    1) This step applies to Word for Mac only: On the View menu, click Print Layout . 2) In the chart, select the data series that you want to plot on a secondary axis, and then click Chart Design tab on the ribbon. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. 3) Click Add Chart Element > Axis Titles > and select between See More…

    How to create charts in Excel?

    1) Select data for the chart. 2) Select Insert > Recommended Charts . 3) Select a chart on the Recommended Charts tab, to preview the chart. 4) Select a chart. 5) Select OK . See More…

    What is a double line in Excel?

    The standard double underline adds two lines to the bottom of all contents in a cell, while the double accounting underline adds two lines to all contents of a cell except currency symbols. 1. Select the cell or range of cells containing the content you want to underline.