Excel Weekly News from Contextures Aug 20, 2013
Pivot chart problems + more Excel tips
In this week's Excel news, you'll see why a pivot chart and pivot table change together, and other tips. Thank you for reading the Excel news!
- Debra firstname.lastname@example.org
The two winner of last week's giveaway, for Vertex42's Spreadsheet Tips Workbook, are Tim and Ute-S. Congratulations!
This week, you can enter the giveaway for a chance to win a copy of my PivotPower Premium add-in, that makes it easier to work with pivot tables. Two winners will be selected.
Go to my blog post, read the rules, and add your comment, to enter the draw for this add-in. The deadline is Wednesday, August 21st, at 12 noon, Eastern time.
Click here to see the details, and to enter the giveaway: PivotPower Premium Giveaway
After you create a pivot table, you can build a pivot chart from the summarized data. However, if you make a change to the pivot chart layout, it will also affect the pivot table layout.
To avoid this problem, you can make another copy of the pivot table, with the layout that you want for your report. Hide the sheet with the original pivot table -- the one that is connected to the pivot chart.
Click here to see the details: Changing Pivot Chart Affects Excel Pivot Table
To remove text from a cell, before or after a specific character, you can use the Find and Replace feature, and a wildcard character. For example, delete any text after a colon, or any text before the word "of".
Remember to make a backup copy of your file before using the Replace All command! It's good insurance in case things don't work right the first time.
Click here to see the details, and to see a video with the steps: Remove Text in Excel Without Macros
Here are a few more Excel articles that I read this week, that you might find useful:
As a consolation to those who didn't win his Charting Utility in the recent giveaway, Jon Peltier has provided a coupon code that you can use to buy the Chart Utility at a 15% discount.
In Excel 2010 and earlier, the default number of sheets in a new Excel file is 3 sheets. Watch this short video to see how to change that setting in Excel 2007. The steps are similar in Excel 2010 -- click the File tab instead of the Office button, and go to the General category in Options.
For more tips on Excel worksheets, please visit my Contextures website: Excel Worksheet Tips
Last week, we spent a few days in Rochester, New York, and visited the National Museum of Play. It's a wonderful place, and I highly recommend it, if you're ever in that area.
In addition to all the exhibits and interactive fun inside, there is a fabulous garden outside. That's were I snapped this picture of the tall sunflower plants. As you can see, it was a beautiful day, with a bright blue sky and a few clouds.
In addition to all the free
Excel tips and tutorials, there are other Excel tools that you can
invest in. To learn more about the products listed below, click
on the links to take a look at their features, and decide if they're
right for you.
Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.
Contextures Inc., Copyright ©2017
All rights reserved.