Create a chart

Office Web Component Chart

Show All

Create a chart

The specific steps for creating a chart depend on the program you are using to design your Web page. For more information, see Help for that program. If your design program Help does not provide a procedure for creating components such as charts, follow these steps:

  1. In your design program, open or create the database, project, or Web page that contains the data you want to use in your chart.
  2. Activate the page where you want to put the chart.
  3. By using the design program's procedure for adding a control to a Web page, designate the location and initial size of the chart component on the Web page.
  4. If the Commands and Options dialog box is not displayed, click the chart to display it.
  5. Specify the data you want to use for the chart in the Data Source tab by selecting Data typed into a data sheet, Data from a database table or query, or Data from the following Web page item.
  6. If you select Data from the following Web page item, you must also select the Web page item (such as a spreadsheet, PivotTable list, or data source control) you want to use in the list. Only items that exist on the Web page where you're creating the chart will be shown in the list.
  7. Specify data settings for one of the following:

    Data typed into a data sheet

    Data from a database table or query

Data Link Properties dialog box

  • Select Data member, table, view, or cube name and select the data member, table, view or cube name from the list or select Command text or SQL and type the connection string you want to use.
  • Under Plot details, select whether series should be in rows or columns by clicking Series By Rows/Columns .
  • If you want to use direct record values from your data, such as when you have created a query that calculates totals on your server, and you want the chart to use those totals rather than calculate its own totals on the client, select the Plot detail records check box.
  • Add data from the field list to the chart drop areas.

    How?

    Data from a Web page item: Spreadsheet

    Data from a Web page item: PivotTable list

    Data from a Web page item: Data source control

  • Click the Type tab, click the type of chart you want to use from the list, and then click the chart sub-type you want to use from the display on the right.
  • Click the chart or an item in the chart to make options available in the Commands and Options dialog box. Different options will be displayed in the dialog box depending on what is selected in the chart. For example, when you select the entire chart, the General tab becomes available (in which you can add a legend or data labels, or make other changes based on the chart type). When you select an axis, the Format, Line/Marker, Axis, and Scale tabs are displayed.