Hello, everybody. Welcome back to the third dashboard. In this video, we will see how to make this particular data in such a way that it feels like average data for the whole, and the selective data will be a little bit darker. To do. So we'll just alter the colors of these points. Just click on one of the points in your graph and right click and format the data series which automatically brings up these fields to the right.

That is Format Data Series under which we have a paint bucket. Just click on the paint bucket, we are not going to edit any lines, we're going to edit the markers. So I just click on marker marker options where we have the marker points. And we can change the marker type if needed. So I'll just select bullet points. That should do it maybe a little bit bigger.

That will be better. Now, after that, we can also select a color. So from the color option we'll make a little bit grayish. That should work though. That's fun for the board. So we do not want the border so let the border be also a little bit gray and fill color we will also be changing.

So from the drop down we'll select a little bit gray again. Now both the parameters are equally gray, so it gives an illusion that only that data has been blurred out and we'll make the orange a little bit darker. So as the color is on we pick a bit darker orange and fill color also a little darker. That should do the trick. There it is. If we wish for some other colors we can change and alter the color as per the desired output.

Let us keep it this way. So there is a record so we can alter it as per. So I'll be doing the changes and I will be getting back. In the next video we will see how to create a drop down and using the drop down control records from the pivot table. and retrieve the respective results on this chart. Till then keep practicing.

See you in the next video. Thank you