How do I make a graph in 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 I add a secondary axis in Excel 2003?

After a series is selected, open the Format Data Series dialog box (type CTRL+1 or click the Format Selection icon). 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 I make a pie chart in Excel 2003?

Creating an Exploding Pie Chart

  1. Select the data to be charted.
  2. On the Standard toolbar, click Chart Wizard. The Chart Wizard – Step 1 of 4 – Chart Type dialog box appears.
  3. From the Chart type scroll box, select Pie.
  4. Under Chart sub-type, select one of the exploded pie charts.
  5. Click Next.
  6. Complete your chart.

How do I create a histogram tool in Excel?

Click Insert > Chart. In the Insert Chart dialog box, under All Charts, click Histogram , and click OK.

How do you graph a secondary 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.

What is a secondary axis in Excel?

A secondary axis allows us to represent and visualize multiple data series without the need to use additional charts. The feature is especially useful when we want to compare data series that are measured in different units or with different scales of comparison.

How do I make a simple graph in Excel?

How to Make a Graph in Excel

  1. Enter your data into Excel.
  2. Choose one of nine graph and chart options to make.
  3. Highlight your data and click ‘Insert’ your desired graph.
  4. Switch the data on each axis, if necessary.
  5. Adjust your data’s layout and colors.
  6. Change the size of your chart’s legend and axis labels.

How do I make a histogram in Excel 2013?

Excel 2013

  1. Make sure you load the Analysis ToolPakto add the Data Analysis command to the Data tab.
  2. On a worksheet, type the input data in one column, and the bin numbers in ascending order in another column.
  3. Click Data > Data Analysis > Histogram > OK.

How do you make a graph in Excel 2007?

In Excel 2007, click on the “Insert” tab. Find and click on the “Charts” section in the insert ribbon. You will find several types of charts (graphs). Click on the Excel chart (Excel graph) that you want to create.

How do you make a graph on a table?

Highlight the table by clicking and dragging the mouse across the entire table. click on the “Insert” tab. Find and click on the “Charts” section in the insert ribbon. You will find several types of charts (graphs). Click on the Excel chart (Excel graph) that you want to create.

How to make a pie chart in Excel?

Click on the Excel chart (Excel graph) that you want to create. For example, if you want to make a pie chart, click on on it.you will then be shown the options for that type of chart.You can make all necessary changes like the chart title, axis titles, data labels, data tables,legend etc. to the Excel graph through such options.

How do I format a chart legend in Excel?

Click to select the chart legend. Click the Format button on the Chart toolbar (or double-click the chart legend). The Format Legend dialog box contains three different tabs—Patterns, Font, and Alignment—that can be used to format the chart title. The Patterns tab lets you define borders and fill colors.