Rock Living
New Member
- Joined
- Mar 4, 2010
- Messages
- 1
Office/Excel 2007
Would like to create a chart comparing:
-average attendance as a # over 7 year period (which declined)
-membership as a # over 7 year period (which increased significantly)
-with % of members attending over same 7 year period (which declined significantly)
Not sure what type of chart to select, nor how to be able to compare two sets of actual #'s, with a separate line that would be a % and how do show all of this data in the same chart. Would greatly apprecaite any advice. Thanks!
Would like to create a chart comparing:
-average attendance as a # over 7 year period (which declined)
-membership as a # over 7 year period (which increased significantly)
-with % of members attending over same 7 year period (which declined significantly)
Not sure what type of chart to select, nor how to be able to compare two sets of actual #'s, with a separate line that would be a % and how do show all of this data in the same chart. Would greatly apprecaite any advice. Thanks!
