Excel Tips
Copy a Chart Detached from the Data »
June 21, 2023
I want to make a copy of the current chart, detached from the data. I have to chart 100 customers, and I want a quick way to move to the next customer, copy the chart, move to the next customer, copy the chart, and so on.
Create a Chart with One Click »
June 19, 2023
I have to create a bunch of charts based on data I already have in Excel. How can I speed up the process?
Use One Slicer For Pivot Tables From Different Data Sets »
June 15, 2023
I have two pivot tables that contain a Product column. The pivot tables come from different data sets, so I can not use one slicer to drive both pivot tables.
Excel 2013 Allows Slicers on Regular Tables »
June 13, 2023
New in Excel 2013, you can filter a regular data set, provided you convert the data to a table using Ctrl+T first.
Excel Data to Mailing Labels in Word »
June 12, 2023
I have address information in Excel and I have to make mailing labels.
Use an Alternate Map for 3D Map »
June 8, 2023
Maybe you want to plot quality performance in a manufacturing plant. Or which displays in a retail store generate the highest sales. The 2015 edition of Power Map lets you replaced the Globe with any alternate map image.
Creating a Video from 3D Map »
June 6, 2023
3D Map will let you tell a story by stringing together a series of scenes. You might show the whole country for 10 seconds, then zoom in to Florida and fly over Florida for a few seconds.
June 5, 2023
I’ve been using 3D Map since the first beta. Igor Peev and the Power Map team have hidden a lot of good settings inside of the product, even if they are not always evident.