In this video we are going to make like this you are looking at you here
Either of these two. I will explain how to make this graph
simply using a Scatter
This graphic is going to be called "Graphic of hoops" although they are not closed
Each of the graphics uses a separate sheet to insert
start and route data
of each of the series. And you can see that they are several blocks
Block for series 1, block for 2 and block for series 3
Have the data for each of the series
And the bottom, which would be this, if you see it here
is the background of the series and this is what I would come to look like it is filling
the bottom of the series is this part that is here that we are going to use
That is not intimidating at all the amount of data that
are watching here, which is really simple and it is very easy we are going to
step by step and we start here explaining them. And this part we started
to drawing the graph, as you can see
the series identified only by colors
red, green and blue, and here below I have the gray bases for
each of these colors. Here later I will add
the labels for the graphic. Then we started defining the first
value as a 90, the start will always be a zero.
The end is defined with a formula, is:
The maximum angle between the maximum value
the value that we want to manifest, plus the beginning
The maximum angle will always be 270, the maximum value will be 100
The account is, the count, of units within each of the series.
We define this here by putting a
We add one to this, and we go down
I have 40 units within each series, see it here?
So, my account is going to be the counting of these series
A lot of attention here! Less one! It is the counting of the units
in each of the series minus 1. You have to give me
a 39, because I'm using 40 nothing else. If someone uses more
It will always be minus 1, it does not matter if you use 80 or 120
It will always be less. The accumulated I define it with
with this formula, which is: The end minus the start
between the account that I am defining. And the index of the series
It's going to be 1.25 in this case. You are going to see inside the graph
because I'm putting 1.25. Here I define the start of the graphics
It's going to be our zero. The next I add the accumulated
I fix the row, super important, and I take it to the bottom
The last data of this part must always be the same
than the FIN data. Here I define the radians
because Excel formulas do not work with degrees
but with radians. "And" I define it with this formula
the COSENE of radians on the index of a series
I leave that formula here and I copy it to this other side
but the change by the formula of the SENO. I take these three formulas
down and I have the values that I occupy
And here we contiamos and add our graphic
of compression or the scatter with smoothed lines
We select the data, and start adding
each of the series. The name of the series, see it here
this one that is here, the values of "X"
And the values of "Y". We arrive here and we give OK
Just to see how it is going, we are removing what does not work
Now we run a bit and we're going to format it
to each of the series. A lot of attention here, the graphic
must have a solid line, the color of our series
as we need it In my case I am defining the series as
red, green and yellow, and the width of the line
It must be larger than the size of the marker. I will use10 for this
and in the marker I will use the default value. As I said, I select
the solid line, the red color and 10 points for the line
If they had not selected the scatter chart with smoothed lines
this check would not be selected then just come here
down and give him check. For the marker, a solid color,
the same color of the line and the edge of my marker should be
with a line solidad with the same color. As you can see, it is beginning to take shape
my graphic Now I continue and I will add the values for
for the following series, I copy
and I paste the formulas in each of the series and I define the value for
each one of them like 80 and 70 as they see change the data
Here I have to put a 1 and here a 0.75
I'll explain why this is this way
The red series is starting at 1.25
I'm defining the truth line, the green series in 1
And I am defining the blue series in 0.75
This makes the red series start here, the truth here, and the blue in this part
this is why I need to define this number that is here
Here I continue with the values that I need to add
and I come here and just, I take the first block I stick it
here, as you see it is changing everything and I paste it here in this other part
I will add the other series for my graphic
As you see it here, our graphics start to take shape
Now I'm going to format each of the series
Very well, it seems that we are progressing a lot and only the
gray background of the graphic, as you see here here that gives the impression
that is being filled by the values that we are adding
Here I come, I select the entire first block and I go to the beginning
I give him copy and I paste it down here. I just have to make a change
very small here. I define the beginning of my graph, the beginning of the degrees
sorry, like the zero, and I add it no longer, the accumulated
the maximum angle divided by the count of units for my graph
I'm going down and over again
This should now be the same as the total of the maximum angle, is 270
As here the series should be the same, I just come and tell him
take the values of the previous series
I will add the series for my graphic
Now I'm going to format each of the series
And here I will add with a small difference, the color, I will use
the gray color for each of the series but always the same
parameters, the same with the marker
And it seems that the bases are covering our values
but that gets fixed very easily we come to the part
where we select the data and upload the gray bases
so that the data can be up and down
the bases and a very important fact is to format
axes. See this here, I come and I define the axis
and excel defines me 1.5, if I make it bigger
this graphic, excel will want to change my axis
Now I have a two, and that's not what I want, I want it to always be 1.5
And this must be in 1.5 always
It is at -1.5 and this at 1.5
now I define the size of my graphics as 3
And we leave this like this, ok
Now I remove the
Now I remove the axes and I am not interested anymore
And we continue in this way, here I am going to add the labels
for my series and because here the blue
green and red, here I define the values
for "X" and for "Y" here always a zero
And in this part I put 0.75 because that's the value
I'm putting for the blue series, I put a 1 and a 1.25
I'm changing the values of
the series so I'm adding in this part
to manipulate them from this side that is here and here the values
of my series, which are 70,
80 and 90, very good, now we continue with the following formula
I bring the name of the tag, the ampersand (&) to be able
paste (join) the data as a text. I open quotation marks two points (:) space
I close quotes & and the TEXT formulas
where will I take the value of my 100 series
and I'm going to give you a percentage format, I close and
This way, I paste the formula for the other labels and that's it.
Now I come to my graphic, I select the data, and I add the name
of the seri going to be blue, the value for "X" it's going to be zero and the value
for "Y" is going to be this one that is here in this part
I already have my series defined for the labels, now what's left
is to add the labels for our series
I'm going to add it to the left
Now I format the labels so they give me the
data that I want, the name of the series and I remove "X" "Y"
in each of the labels that I am defining here
And our graph is already beginning to take shape, we remove what
we no longer need, we copy the graphic we go to the dashboard and paste here
This is an issue and now to give a bit of format each one will
as you need it
As you already have my graphic defined
To be able to use it where I want
And the labels that they sometimes want to make as if they
They will send themselves, but it does not happen that way.
As they saw it, it was not difficult to do
these graphics. And if you wanted to download the file that I used
to generate this video can go to the description
and find my social networks there, my Patreon page
And there in Patreon is where they will be able to download the file.
And one of the advantages of having the file is that if I did it
in English or Spanish, when they download it, Excel will interpret
and will translate the functions and that's going
to help to understand it in their language if it is not
They do not have it in Spanish or English or whatever language it is.
I will try to upload a video every week which
implies a somewhat large level of effort
If you support me by liking the video, sharing it
and entering, again, my Patreon, and supporting me, I will thank them a lot.
Well, for now, nothing more, I hope you are very well
and that they have enjoyed it and understood it, if not, they see it again.
Until next time, thank you very much. Bye!
Không có nhận xét nào:
Đăng nhận xét