Insert a chart
Follow these steps to insert and manage charts in the Report Designer.
note
- Charts can't use data from repeating cells. Create separate total rows for different accounts or groups.
- You'll see a light-blue tag in cells with charts. The chart only shows when you preview or print.
- Always put the chart in the same area as its data.
- Select the cell where you want to insert the chart.
- SelectInsert, thenChart.
- Set up your chart:
- Type: Select a chart style in theTypetab.
- Data: In theSource Datatab, enter the cell range for your data in theCell rangefield. For example, for Total Assets in a Balance Sheet, enterB27:D27.
- Labels: Define labels for your data points and legend entries.
- Chart Area: Add a title, subtitle, and set the chart's size and border in theChart Area Propertiestab.
- 3D Effect: MarkDisplay in 3Din thePlot Area Propertiestab if you want a 3D look.
- Axes: Add grid lines and format the X and Y axes in theAxes Propertiestab.
- Colors: Choose your color scheme in theSeries Propertiestab.
- Legend: Decide if you want a legend and where to put it in theLegend Propertiestab.
- SelectOKto save your chart.
- To change an existing chart, select its row, then selectFormatandChart.
- To remove a chart, select its cell, thenInsertandRemove Chart.