Create a chart based on a spreadsheet

MS OFfice Web Components Spreadsheet

Show All

Create a chart based on a spreadsheet

If you publish a spreadsheet from Microsoft Excel, you can take advantage of extensive Excel charting capabilities to create a chart based on spreadsheet data and publish the chart with the spreadsheet. This is one of the easiest ways to create a chart based on a spreadsheet.

In other design programs, you can create a spreadsheet and a chart by using two Microsoft Office Web Components: the Spreadsheet Component and the Chart Component.

Follow these steps to create a chart for your spreadsheet.

  1. Following the directions in your design program, use the Spreadsheet Component to create the spreadsheet on a Web page, and then add the data you want to use in your chart.
  2. Following the directions in your design program, use the Chart Component to create a chart on the same Web page where the spreadsheet exists.
  3. If the Commands and Options dialog box does not appear, click the chart.
  4. On the Data Source tab, under Select where the chart data comes from, click Data from the following Web page item.
  5. Click the spreadsheet item in the list.
  6. Under Set details for the data type, click Ranges.
  7. Do one of the following:

    Specify all the data at one time

    Specify one series of data at a time

  8. Click the Type tab, and then select the type of chart you want.

Note   For help with Chart commands and options such as formatting and modifying the chart, click Help on the General tab of the chart Commands and Options dialog box.