stacked area chart with varying fills

[theorbo]

Hello. I have a stacked-area chart. The X-axis is age and the Y-axis is the
number of hours spent on an activity. The data series represent various
groups of people. I would like to show one other variable - money spent on
the activity as it isn't directly correlated with the hours spent.

I've been envisioning some form of gradation in the series' area fills (like
heat maps or topography) but am unsure how to do that or if it's even
possible.

Any other ideas? I need to show variation within the stacked-area polygons.
I know that some people may advise to break this chart up into multiple
charts but I need a solution that has the entire solution on one graph or
map.

Thanks for any ideas or comments on what you would do.

 

[Jon Peltier]

I don't really get what you're stacking from your description.

Here's a different approach. put age in the first column, money and time in
the next two columns. Make an XY chart of money vs. time. Use one of these
programs to apply the ages in the first column as data labels on the points:

Rob Bovey's Chart Labeler, http://appspro.com/Utilities/ChartLabeler.htm
John Walkenbach's Chart Tools,
http://www.j-walk.com/ss/excel/files/charttools.htm

- Jon