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 ddalgleish@contextures.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:

  1. Chandoo shows how to find the lowest value in a row, and then match that with the vendor name in the column headings.
  2. 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.
  3. 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.
  4. 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.

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

Towering Sunflower

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.


Contextures Products

Save time with our "Done For You" Excel products.


Note: I am an affiliate for some of the products mentioned in this newsletter, and earn a commission on the sales.




Privacy Policy


Contextures Inc., Copyright 2019
All rights reserved.