Data sets and for training and practicing you can now download the data set for this dashboard for free from our website let's continue select one of the options button right-click format.
Control then choose the cell link here we will choose j4 cell name now as you can see each option button has a specific number from 1 2 and 3. so now we got two different values one from.
The option buttons and the other one from the spinner now we will start to create non-duplicable number to extract the correct values based on the spinner and.
Option button values Now link each year in a declining order foreign groups one for the purchases items and one for the total sales and the third.
For the final profits next we will combine the year with the option button value using the concatenate formula great so now this twenty thousand one.
Hundred ninety one is a non-duplicable number and it means the purchases items for 2019 so link each cell with the related header .
Foreign both values in a combined way same like what we did here as you see it change depends on the options button and Spinner selection.
So now we can create a dynamic line chart first we need to add the weak numbers then we will use vlookup formula to find the header name.
Look finally use the index formula and match formula to get the correct value now the line chart data source is ready select all then insert line chart.
- Excel Today - Using Excel for Data Analysis
- Cara Praktis Membuat Cap Stempel Digital Hanya dengan Microsoft Word PowerPoint
- Photography Events Logo Vector Free Download In AI EPS Urdu Hindi Illustrator Tutorial
Then finally move the chart to the - ID Card Make
Dashboard next we need to get the amounts by quarters some first 13 weeks to get the amounts.For the first quarter the next 13 weeks will be for the second quarter do the same for the third and fourth quarter.
Finally sum all quarter to get the yearly amount duplicate these text boxes to link the amounts next we need to add a dynamic chart.
Title we added previously the required titles if the options button value equals to 1 so show the first title and so on thank you.
Foreign next we will also use the vlookup to get the values from the second data table foreign.
Add these values to the dashboard foreign ER and the options button but from the format control relink the cell name.
That's all for today's video hope you learned something useful for you on the other hand you have an easy way to directly purchase this template from our website other dashlevels.com.
