Excel hell

I really hate Excel sometimes. It does a lot of good things, but it seems that it tries to do too much, and it's quirks are not cute.

For example, graph templates. Generally once I get the pretty columns/dots/whatever in the shape/color I want, I save the format in a template. For extra goodness, I'll resize it to the size relative to the page that I want, and get the fonts in the size I want.

Last week, I tried to make some graphs in a previously saved template. Once the source data was identified, the graph was so small, it was difficult to resize it so that it was visible.

Bitched to our resident Excel guru, and he said to make a workbook template.

Nice idea, but my data and in which format I present it is always changing based on what the boss wants that day.

"Why does the graph template make everything all screwed up?" I whine. BTW: because of the small graph size, it decided that the appropiate font size is 5 point (important later).

This week, I make the same data using the same template. A bit smaller than the ideal size, but it's big enough to make it easy to work with. A big sigh of relief.

Need to add significant stars. Click on the text box, and it's fixiated on 5 point font.

Easy to remedy, but it's enough quirks to make you want to scream. I hope in retraining everything in 12 point font will keep it that way.

We won't even discuss why I need to remake a few graphs that were already generated. I'll just drink some more gluten-free beer....