View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
VB VB is offline
external usenet poster
 
Posts: 10
Default Representing Dual Data in a Stacked Bar Chart

Here is my data:
Location Flowers Trees
Year 1 Year 2 Year 1 Year 2
Texas 55 63 36 14
Florida 67 75 24 21
NJ 32 27 52 10
Colorado 35 41 35 9
California 84 126 78 39

I want a stacked bar chart that shows Flowers & Trees for Year 1 next to
another stacked bar for Year 2, grouped by location shown along the X axis.
Please help, all I could come up with is a Stacked bar for Year 1, overlayed
by 2 separate line graphs for Flowers/Yr2 and Trees/Yr2.

--
VB