I need to create a chart in Excel 2010 that shows the average number of credits students have attempted, the avg number attained, and the success rate as a %. The first two items are just plain numbers usually in the 5.1 to 10.2 range. However, the success rate is a % more like 84%. Obviously, the same scale won't work for both. I know you can create a secondary axis but, when I do that, the secondary axis columns overlay the primary columns and nothing I can do changes that.
I know I can create a combo chart but all the examples I find are combination of column and line which isn't appropriate for my chart.
Thanks for any help that you can offer,
Kate
I know I can create a combo chart but all the examples I find are combination of column and line which isn't appropriate for my chart.
Thanks for any help that you can offer,
Kate