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.
- 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.
- Following the directions in your design program, use the Chart Component to create a chart on the same Web page where the spreadsheet exists.
- If the Commands and Options dialog box does not appear, click the chart.
- On the Data Source tab, under Select where the chart data comes from, click Data from the following Web page item.
- Click the spreadsheet item in the list.
- Under Set details for the data type, click Ranges.
- Do one of the following:
Specify all the data at one time
-
Under Set ranges in one step, enter the reference of the data range you want to chart, separating the two cells by a colon (:) in the Data range box. For example, if the data you want to use is in a continuous range from cell A1 through cell G5 in the spreadsheet, type A1:G5 in the Data range box.
-
Click OK.
-
Next to Series in, click Rows or Columns to specify the location of your series data.
Specify one series of data at a time
-
Under Series, click Add.
-
If you want to give the series a descriptive name, replace the default name in the Series name box with the name that you want.
-
In the Category Labels box, type the cell references to the category labels for that series. For example, if the series you are adding is in cells A2 through G2, and the category labels are in cells A1 through G1, type A1:G1.
-
In the Values box, type the range reference for the values for that series. For example, if the series data is in cells A2 through G2 on the spreadsheet, type A2:G2.
-
Repeat the previous steps for each series of data you want to add.
-
- 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.