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.

1

1

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

Male_Female_Pie_Chart

Male_Female_Pie_Chart_2

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

1

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)

1

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

1

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

1

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

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.

1