got it! At one point I had highlited all of the sheets in my workbook. Some
how excel grouped them together and wouldn't let me do certain functions.
Anyways, to fix this I highlited all of my sheets and then right clicked on
the selection. One of the options is to ungroup sheets. I chose this and now
I can edit my charts etc.