Help needed with a combination chart.. please read.

[Hales008]

Hello Everyone,

Here is my other post regarding another chart I'm having problems with.

This chart is to display a bar, area and trend line. The bar chart shows Monthly Bid Values for a year - Jan05, Feb05, March05, Jan06, Feb06 etc... The Area chart shows the Quarterly average, and the trend line is through monthly success rate.

The selection criteria for this is for status, Awarded, Completed and Rejected. This is where I am stuck.

The monthly bar and quarterly area are to show status Awarded only, and the success rate trend line is to show the status Awarded, Completed and Rejected. It's basically Awarded / Awarded + Completed + Rejected

Does anyone know how I can do this? This chart is very similar to the one I've already posted for advice.

Many thanks in advance.

Hayley

 

[Dan3D]

If no one proposes a better solution, you may want to check out CRChart, the add-on charting library for CR.
It has much better support for bar/line/area combo charts.

-Dan

disclaimer: this product costs money. I work for the company that makes this product.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com