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 email@example.com
PivotPower Premium Giveaway
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
Changing Pivot Chart Affects Excel Pivot Table
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
Remove Text in Excel Without Macros
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
More Excel Tips
Here are a few more Excel articles that I read this week, that you might find useful:
- Chandoo shows how to find the lowest value in a row, and then match that with the vendor name in the column headings.
- If a workbook has lots of sheets, it can be difficult to navigate through all those sheet tabs. Ross McLean has a free add-in that creates a list of sheets, at the left hand side of the screen, in a custom task pane.
- For a humorous peek at what other people are saying about Excel, read this week's collection of Excel tweets, on my Excel Theatre blog.
- On the Spreadsheet Journalism blog, Abbott Katz shows how he analyzed a large set of food establishment health ratings, using Excel pivot tables and pattern spotting. The article is in two parts -- Part 1 and Part 2.
Chart Utility Discount
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.
- Click this link to go to the order page
- Click the "Add to Cart" button, then enter the coupon code 55Ec9QGz in the order window.
- The coupon will expire tomorrow -- Wednesday, 21 August, 2013 -- at 11:59:59 pm Eastern time.
Video: Change Number of Sheets in New Excel Files
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.
Recommended Excel Tools
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.
- Contextures PivotPower Premium Add-in
- Contextures 30 Excel Functions in 30 Days
- Excel Online Course
- Excel Charting Tools
- Excel Dashboard Kits
- Excel Project Management Templates
- Excel VBA School
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.