View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default stacked area chart with varying fills

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
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"theorbo" wrote in message
...
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.