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.


Move a Chart »

June 20, 2023

I created a chart and it is in the wrong place. How do I move it?


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.


Fine-Tuning 3D Maps »

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.