In this scenario we will learn how to eliminate distractions from our.
So our friend John is now working as a marketing head and an online matrimonial site.
And he wants to compare the marriage rate for people with different levels of education.
My levels of education.
I mean that someone has cleared high school level.
Someone has done graduation to one out and post graduation.
So what is the mandate for different levels of education.
And he also wants to look at the trend of all the states changing or each of these levels of education
over a period of five years
so.
Collect the data for the different levels of education and for the last five years and plotted into
a cluster column chart.
This is how his chart looks like
the first set of columns is what all of the sample and the other four is what individual category that
is.
This is a set of people who have done less than high school.
This is a set of people who have played high school.
These people have gone to some college and these people have bachelor's or more qualification and the
height of this column is giving us the marriage date or the five year period.
So although by removing the primary x's and gray lines drawn this time has a wider clutter in the graph.
But is this graph clearly communicating the message.
And later we can suggest something to John to make it more plain and precise.
Take some time to think about it.
One thing John would be willing to communicate from this graph is that the marriage date for this set
of people is a little higher than others.
That is there is some exception here.
Others are below 41 or 42 and this one is going up to sixty one.
So this series is having some exceptional values so he may want to highlight this graph which is not
clear from this.
To do that one option is be emphasizing on these blogs and emphasizing on this one so you can clearly
see that this part of the graph is being emphasized and the focus of audience straight away goes to
this colored part
and since the point we want to make is that it is the largest which is very clear from the height of
these but
so one way of eliminating distraction caused by the other bars in a bar chart is to be emphasized them
and highlighting the one that you want to convey the message.
And if you want to go lonely bars like this you can individually select the bars and change the color
to great to be emphasize them and the ones you want to emphasize on.
You can select those bars and danger to color to some bright color like this orange one or bluer black
now.
One other alternative to representing this graph using a bottom floor is to draw a line.
Jack
let me show you a line chart that can be drawn with the same data
so if you remember there are two things John wanted to do.
One is to compare the marriage date of different categories of people and the second thing is to see
the trend of each of these categories over the years.
So by drawing this line chart we have eliminated a number of distractions.
One of the biggest change that we have made is that we have moved from a bar graph to a line graph.
First of all a line glove typically makes it easier for us to see the trend over time.
Secondly when we had 25 bars in the previous graph the same information is being given by four lengths
to.
Clearly we have reduced a lot of clutter so organizing the data in this line graph allows us to use
a single x axis which can be leveraged across all the categories and highlighting the data points like
this helps us compare the performance of each category against the other.
So the two aims of comparing the performance of each category against the other and seeing the trend
of each individual category is clearly met with this small graph which is clean and clutter free.
Drawing this graph is that easy on the x axis.
The winner take the year's
and we will plot these four data series as line jobs.
We will remove all the gray lines the more divide axis.
I laid the end point and give it data labeled manually or you can add data labeled for all the points
and manually remove the ones that you do not want to show.
Then we will add these ligand names as separate text boxes.
We will change the color of those data series which we want to be emphasized.
We will highlight the data series in a bright color which we want the audience to focus on the text
color of the larger names should also match with the color of the plotted lines.
So this is how we create this chart which is free of any distraction.