Explain the procedure to create chart with CHECK-BOX?
Enable Developer Tab
Click on INSERT
Select CHECKBOX
Place the check box in blank cell as per your requirement
Create 3 check boxes for required table headers
Right click on Check-box
Select "Format control"
select a cell to dispaly value of check-box
Now i am selected B10 cell
If we select the check box relevant cell displays as TRUE otherwise FALSE
Repeat the same process and assign a cell to display the values against the EXPENSES check box
Repeat the same process and assign a cell to display the values against the PROFIT check box
Copy the table structure beldow TRUE
Use IF function to copy the data in table
Drag the formula for all the required cells
Repeat the same process for EXPENSES
Drag the formule for all the required cells
Repeat the same process for PROFIT
drag the formula for all the required cells
Select data and create chart
Now chart created
Convert Normal chart into thermometer chart
Right click on SALES series in chart
Increase OVERLAP percentage to 100
Select No fill for sales portion
Right click on PROFIT Series
Select the option of CHANGE SERIES CHART TYPE
Select LINE chart
Click on OK