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.
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.