[August 15, 2009]
Summer is on the wane. I can hear the crickets chirping in the evenings now and that is a sure sign that summer will not be here for much longer. It makes me sad to see the end of summer. Even though we have the same amount of chores and we still have a job to go to, the pace of life just seems slower to me somehow. We have a lot more light at the end of the day and I can linger on the porch and watch the sun set. It's just a bit more relaxing and I can sit there and clear my mind and settle down after all the hubub of the day.
But we have September around the corner and that is always fun as well - kids going back to school, pumpkins and as the air turns cooler I get the itch to start baking again. I guess I like all the seasons but summer is truly is my favorite!
I just returned from the Eastern Shore yesterday where most of my extended family lives. I traveled back this time for a sad occasion; one of my dear cousins had passed away. As I sat in the tiny country church waiting for the service to begin I was looking at the old scarred pews and my thoughts began to wander... I realized that my dad had sat in these very same pews as a young boy that I had sat in when I was a little girl. Heck, my parents and all my aunts and uncles had been married here and their children baptized as well. Lots and lots of history where I sat. I remembered walking to church with my grandmother as a little girl (it's a very small town) and taking flowers for the altar too. I guess my point is that even though it was a sad occasion I was glad that I was prompted to remember such happy times. Much like the changing of the seasons, so too do our lives change - endings and beginnings - life is like a big circle.
Please join me in welcoming Stephani, Alex, Malcolm, and Peter as the latest premium subscribers to Carol's Word Bytes Newsletter. Welcome to the family! If you know someone who struggles with an application in Microsoft Office, like Word or Excel, do them a favor and tell them about our newsletter. They will always thank you for it! If you aren't a premium subscriber, don't you think you should be?
Let's get to the tips now!
Table of Contents
Change the Layout of your Charts from Rows to Colums In MS Excel - How do you do that??
Adding Comments to a Formula in MS Excel - This is pretty cool!
Change the Name of the Comment Author in MS Excel - Let's take the fame or blame!
 |
|
Change the Layout of your Charts from Row to Column
When you create a chart, MS Excel will check the number of rows and columns. In a chart created automatically, by clicking F11, rows from the data table are created on the category axis. You may however, sometime later decide that you would like to switch from rows to columns in the category axis. Fortunately, this is not difficult to accomplish:
Follow the steps below to learn how:
- Select the chart.
- From the Chart menu, select Source Data.
- In Series in, select Columns.
Told you it was easy!
Adding Comments to a Formula in MS Excel
Sometimes you would just love to have a comment that would make things clearer for the person using the worksheet in MS Excel wouldn't you?
Well you can use this handly little trick to add a comment to a formula in MS Excel:
- At the end of your formula, add a plus sign (+), the N function, and an open parentheses.
- Key in your comment in quotation marks.
- Close the parentheses.
You can view the comment in the formula bar whenever you select the cell.
Change the Name of the Comment Author
By default, in MS Excel each comment includes the author's name. To change or cancel the name of the author of the comment, follow the steps below:
Click on Tools | Options | General | User name.
Change or delete the user name to your liking.
This change will only apply to any new comments that you insert.
Included in the Premium Newsletter:
- Default Chart Colors in MS Excel
- Default Reminder Times and Sounds in MS Outlook
- Add a Calculated Percentage Field in your MS Excel PivotTable Report
- Share your MS Word Document with a WordPerfect User
- Navigating in MS Word
- Take Pictures in MS Excel
Shouldn't you be a premium subscriber?? With a premium subscription, you get more than double the content and NO advertising! Plus, most instructions come with clear screenshots! With your premium subscription you also receive access to an archive of five years of newsletters and deep discounts on all books and tutorials I publish!! So what are you waiting for? Sign up today!
Carol's Corner Office members receive the premium edition of the Word Bytes Newsletter. To become a member click HERE.