Component Solution Services REC02F Manuel d'utilisateur télécharger pdf (Page 73)

Tips Recipes Brio 2002

Section Type: Report section

Tip Name: Multi-Line Bar Chart

Purpose / Use: To display a Bar-Line Chart that has 1 bar and multiple lines.

Sample File: Multi-line bar chart.bqy

Steps to Produce: Create a report section with no groups, embed a specially formatted bar-

line chart and design a custom chart legend in the report section.

The challenge stems from the fact that bar-line charts work with pairs of values, one being a bar

and one being a line. The trick is getting the chart and its legend to display only the first value as

a bar and all others as lines.

1) In the Results section, create a computed item named “Dummy” with a formula of 0.

2) Add a new chart and change its chart type to be a bar-line chart by selecting the last item in

the chart type pulldown.

3) Drag the field to be displayed as a bar into the Outliner as the first item in the Y-Facts area.

4) Drag the field to be displayed as the first line into the Outliner as the next item in the Y-

Facts area.

5) Create subsequent bar-line groupings by dragging the Dummy field as the bar (with a

value of zero) and the next line-oriented field as its bar-line group partner. Your chart

should now look like this:

1 2 ... 68 69 70 71 72 73 74 75 76 77 78

Pas de commentaire

Component Solution Services REC02F Manuel d'utilisateur Page 73