Specifying chart data area

You can configure a chart to display spreadsheet document data.

Suppose that a spreadsheet document contains data.

Fig. 260. A spreadsheet document. Chart data area

To create a histogram based on this data:

  • Select a cell range that contains data (marked with a border in this example).
  • On the main menu, point to Table, point to Pictures, and click Chart.
  • Select an area for drawing a chart.

This adds a chart that displays the specified data in graphical form. You can customize the chart appearance, title, area sizes, colors, and many other parameters using the chart property palette.

Fig. 261. A spreadsheet document. Adding a chart

To customize a chart, on the main menu, point to Edit and click Properties.

Next page: Managing OLE objects


Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.