Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cross-tab graph with 3 summary fields

Status
Not open for further replies.

selvirino

Programmer
Jun 18, 2001
17
US
I have a cross tab with three summary field values for financials by quarter. The cross tab looks something like:

Q1 Q2 Q3 Q4 Total
-------------------------------------------------------
Program #1 | <Baseline>
| <Projected>
| <Actual>
|
Program #2 | <Baseline>
| <Projected>
| <Actual>
. |
. |
Program n | <Baseline>
| <Projected>
| <Actual>
|
Total: | <Baseline>
| <Projected>
| <Actual>

Where Baseline, Projected, and Actual amounts appear for each quarter.

I want to represent this information in a chart. I created a 3-D Riser chart, but could not display all numbers in the same chart. I tried creating different 3-D Riser charts, and setting two of those to have no walls, etc. and atransparent background, and then overlayed the three charts. This did not work.

Basically, I would like a way to show the data in a single chart, using colors, shading, or patterns to distinguish between the different types of financials.

Any help will be most appreciated.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top