Sun 28 Oct 2018

Article 48 - Show Pictures Conditionally

By |Sunday, October 28th, 2018|Categories: Articles|Tags: , , , |0 Comments

Sat 17 Oct 2015

Tips & Tricks 113 - Drag and Drop a Picture in Excel Sheet

By |Saturday, October 17th, 2015|Categories: Tips and Tricks|Tags: , , , , , , , , |0 Comments

Try dragging and dropping a picture in a worksheet - What happens. You will notice a plug sign which means that a picture will be added. But when you release the cursor to drop the picture in Excel sheet nothing happens.

Reason - Excel doesn't support dragging and dropping the picture in a worksheet.

Now, what to do. If you are dealing with too many pictures, it is cumbersome to use Insert > Picture command.

Fortunately, there is a work around in place. Microsoft Word supports dragging and dropping of pictures. Also good thing is that, you can select all your pictures in one go and drop in Word document.

Now, you can either drag and drop the pictures from the Word document in Excel sheet or you can cut/copy and paste from Word to Excel sheet.

Side Note - OpenOffice / Libre Office supports drag and drop to their respective spreadsheet programs. (Note, but you can not drag or copy and paste pictures into Excel from Open Office / Libre Office spreadhseets like you can drag or copy / paste from Word)

Sun 06 Sep 2015

Solution - Challenge 21 – Male Female Pie Chart with Pictures

By |Sunday, September 06th, 2015|Categories: Solutions|Tags: , , |0 Comments

-- The workbook related to this solution can be downloaded from Solution - Challenge 21 – Male Female Pie Chart with Pictures --

Below is a possible solution to the challenge - Challenge 21 – Male Female Pie Chart with Pictures

Download the files related to this challenge as given in the problem -

Male_Female_Pie_Chart Excel File  Male Picture -1st Pie  |  Female Picture - 1st Pie
Male Parliamentarian - 2nd Pie
  |  Female Parliamentarian - 2nd Pie  |  Parliament - 2nd Pie

First Pie Chart

1. Create a Pie Chart on the data.
2. Drag the pies apart by double clicking one pie which creates a gap between two pie slices.
3. Delete the Legends (M / F)
4. Changed the title to "Parliament Representation" and make Font Bold and White.
5. Fill the title box with appropriate Green color.
6. Right click > Format Chart Title > Format it with Soft Edge (2.5 points)
7. Double click on one pie and give it appropriate Glow. Do the same with other pie.
8. Select the chart > Design Menu > Add Chart Element > Data Lables > Center. Now format the number (%age) appropriately in White and Bold.
9. Select the chart and Insert > Picture > Female_Small.png and do the same for Male_Small.png
10. Adjust the placements of Male and Female pictures.

You now get the pie which you want.

Male_Female_Pie_Chart

Second Pie Chart

1. Repeat steps 1 to 8 as in First Pie Chart instructions.
2. Select the chart and Insert > Picture > Male_Parliament.png and do the same for Female_Parliament.png and Parliament.png
3. Adjust the placement of all 3 pictures.

You now get the pie which you want.

Male_Female_Pie_Chart_2