00:00Let me show you how you can create this Star Wars theme slash lightsaber line chart in Excel,
00:04which also identifies minimum and maximum values in your data set with a marker.
00:08We'll use the formula to fill the minimum column.
00:11It checks if values in cell C6 is equal to the array's minimum value.
00:16If it's true, it returns the cell value of C6, otherwise you'll assign a pound NA, not available error.
00:22Similar to that, for the maximum column, we'll use the same formula and we'll replace the min to max function.
00:28After that, we'll apply the same formula for all the rows.
00:31Now to insert the chart, press Ctrl A to select your data set and alternate F1 to insert a chart.
00:36Resize and reposition the chart.
00:38Then after that, go to chart design, change chart type, combo.
00:42And for the revenue, we're going to assign this line.
00:44For minimum and max, we're going to assign line with marker.
00:47After that, click OK.
00:48Now, select your line chart's background like this and then right click on it.
00:53Format chart area from the context menu.
00:55And then we're going to fill the background of the chart with a black color.
00:59Now select your major grid and then change the line color to be a bit dark so that it blends
01:04with the background.
01:05Now, you're going to change the marker color.
01:08Select your minimum marker.
01:10Select fill in line.
01:11And then make sure you select the marker.
01:13And then fill color to be blue.
01:15And do the same thing with the maximum marker.
01:18Same color as blue.
01:19Now, you select the line chart and then change the line chart color to be red.
01:25And then click on effects here and select the preset glow to this one here.
01:30And then change the color of the glow to be red and the size to be six points.
01:36And then you are done.
01:37May the force be with you.
Comments