Creating a chart using single set of formulas

[piercey]

Hi all,

I'm trying to create a chart in a Report Footer section.

The report will reference 12 formulas (residing in the same section) each of which represent a monthly percentage value. I would like to create a Line Chart with a line linking each of the 12 values.

The problem is that when I place the 12 formulas in the 'show values' window nothing appears in the report. This is probably because the chart is expecting grouped data which increments each time it breaks, rather than 12 formulas.

Any ideas how I could get my chart to work?

Many thanks.

 

[CR85user]

Two things I would quickly check - 1st the section above show value that says 'on change of' try 'for all records'

Also try a few of the other default templates - You may discover another preset chart more suited to display your 'static' data.


Good Luck

J