Our friend John is backward with a debt problem this time Don is working at a fund raising non-profit
organization where he's working as a marketing head.
And he wants to compare the contribution of the community in different sectors.
So for example he has identified five sectors such as education health and so on.
And he also compared the contribution in each of these sectors and also see the trend of each of these
sectors over the last six years.
So John collects data of contribution in each of these sectors for the last six years and plotted using
a line judge.
This is all John's line.
Looks like you can see in the legions that we have five sectors arts and culture education health one
services and others.
These five industries are plotted with five different lines and on the x axis we have six years these
lines which are tangling with each other.
Looks like spaghetti noodles.
That is why it is also known as a spaghetti plot.
Now as you can see a spaghetti plot is not as informative and due to the crisscrossing of these lines.
It is very confusing.
So how do we handle a spaghetti plot.
That is a combination of multiple data cities which are tangling with each other.
The first solution that I am showing you is highlighting one series at a time.
So as I told you aim of John is to first compare the performance of one sector against the others and
secondly look at its string over the years.
One way of doing this is by deemphasizing on the other cities and picking up one data series on which
we will emphasize that is will focus the attention of the audience.
So in this graph I have big education data cities.
I have highlighted the end point which is the most recent value of these data cities I have named diligent
here only at the end of this state as it is.
So whenever I look at this blog my focus is drawn towards this data sees its trend and its final value
that is 60 percent in the last year.
So one way of controlling the information overflow and the conclusion to do crisscrossing is to deemphasize
a dark data series and emphasize on only one at a time.
And you can imagine how two brothers this we have covered in the formatting options and the lecture
in which we do about how to format a graph.
So if you want to draw this you just used the previous graph select these four data series and color
them late.
Great.
Do not use any data markers or better labeled for this series which you want to emphasize on use of
bright color.
Probably a blue or a black color
and in the end add a text box and highlight this last value and the legit name while highlighting a
particular data series.
You can use your bank colors also.
For example if your company's brand color is raped you can use a red line to show that that particular
data series belongs to your company's performance and the other data it is belongs to other companies
performing it
the second Northerner do of showing the information in a spaghetti graph is to segregate all of these
individual lines so you can look at this example.
I have plotted all of these independently.
These are five different line charts with no access or great lengths to only align with endpoints highlighted
and a corresponding letter name given enough x box to load all these up not using a common primary axis.
Still since the end points are labor and I wanted to highlight the trend it is clearly visible so you
can see the performance of each of these and the trend that following over the six years that I have.
So if you compare this chart with this one clearly clearly the alternative to US bigger deplored are
more informative and more effective in conveying the message.