Thu 18 Feb 2016

Downloads 01 - Template 01 - A Different Kind of Pareto Chart Template

By |Thursday, February 18th, 2016|Categories: Downloads|Tags: , , , , , , , , , , , , , |0 Comments

Download this Pareto Chart Template from Template 01 - Pareto Chart Template

This Pareto Chart Template is different from commonly found Pareto Chart Templates. It not only gives a slider bar to adjust your percentage which is typically 80% to any other percentage but it also gives a vertical bar. The combination of vertical bars and horizontal helps you to find out problem areas in a ziffy.



Sat 18 Jul 2015

Challenge 21 - Male Female Pie Chart with Pictures

By |Saturday, July 18th, 2015|Categories: Challenges|Tags: , , , , , , |1 Comment

This time, you have a challenge to create a Male Female Percentage chart with pictures of Male and Female to denote the labeling of pie slices. There are 2 pie charts for your challenge.

The files related to this can be downloaded from following links -

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



Note - You can post you answer in comments.

Note - Solution to this challenge will be published after 1 month i.e. on 17-Aug-15.

Mon 13 Jul 2015

Solution - Challenge 5 – Prepare a Graphical Chart

By |Monday, July 13th, 2015|Categories: Solutions|Tags: , , , , |0 Comments

Below is a possible solution to the challenge - Challenge 5 – Prepare a Graphical Chart

1. Download the Challenge file - Tiger Count

2. Right click on Tiger's picture > Cut > Open Microsoft Paint or any other picture editor> Paste > Save the picture

3. Select A1:B7 in Tiger Count file.

4. Create a column chart.

5. Remove vertical and horizontal lines, if any, by selecting them and deleting them.

6. Click anywhere in the graph > Design tab > Add Chart Elements > Data Labels > Outside End

7. Click any data label > Home tab > Fill with black Colour > Bold the Text and make Font White. Adjust font size, if needed.

8. Right Click on any data label > Format Data Axis > Size & Properties > Text Direction > Rotate All Text 270


9. Right Click on x axis and repeat step 7 for x axis also.

10. Select Title Box > Fill with Green Colour > Bold the Text and make Font Color White

11. Click anywhere in the graph > In the Fill, select Picture or Texture Fill > Insert Picture from File > Select the Picture of Tiger (At this stage, Excel may try to connect to internet. Choose Work offline here)


12. Right click on any column and fill it with White Colour.

The solution worksheet can be downloaded from here - Solution -Challenge 5 – Prepare a Graphical Chart

Sat 06 Dec 2014

Challenge 5 - Prepare a Graphical Chart

By |Saturday, December 06th, 2014|Categories: Challenges|Tags: , , , , |1 Comment

This time, it is a challenge to make a chart like below.

The relevant data points and picture are in the Excel file which can be download from here. Tiger Count


Note - You may choose to post the response in comments section.

Sat 29 Nov 2014

Tips & Tricks 67 - Show the Complete Data in Chart even though Data is Filtered

By |Saturday, November 29th, 2014|Categories: Tips and Tricks|Tags: , , , , |0 Comments

By default, charts in excel show filtered data only.

To show complete data i.e. to ignore filtering -

1. Right click on Chart and click on Select Data.

2. Click on Hidden and Empty Cells at the bottom


3. Select Show data in hidden rows and columns. Now, you will have the result which you want.

Sat 07 Jun 2014

Tips & Tricks 8 - Change Order of Legends in a Chart

By |Saturday, June 07th, 2014|Categories: Tips and Tricks|Tags: , , , , |0 Comments

1. Click the chart and click on Select data.

2. Here in the left pane, you can click on a legend name and make it up and down through click on up / down arrows.