thermometer graph with reaching your goals

Erica Esson

Does anyone know how to create a thermometer graph using Crystal Report?

James Andrews

Erica Esson:
Does anyone know how to create a thermometer graph using Crystal Report?

Ah, the dreaded thermometer chart. There isn't one natively.

You can do a stacked bar chart, where if you're trying to show the progress of {actual} to {goal}, you set up a formula that is {@remaining}, which is basically {goal} - {actual}.

Then you set up a stacked bar chart with sum of {actual} and {@remaining} as your summary fields. You'll have to fiddle with it but you can end up with something pretty close.

Erica Esson

James Andrews:
Ah, the dreaded thermometer chart. There isn't one natively.

You can do a stacked bar chart, where if you're trying to show the progress of {actual} to {goal}, you set up a formula that is {@remaining}, which is basically {goal} - {actual}.

Then you set up a stacked bar chart with sum of {actual} and {@remaining} as your summary fields. You'll have to fiddle with it but you can end up with something pretty close.

Thank you for your suggestion. I'm not able to summarize the formulas.