Click in the Cell Link box, and then on the worksheet, click inĬell A9, to link the check box to that cell.Right-click on the check box in cell A3, and click Format Control.The next step is to connect each check box to a related cell in the duplicate Copy the check box, and paste copies in cells A4 and A5.Remove the text from the check box caption, and make the check.On the worksheet, click in cell A3, to add a check box.Click the Insert command, and in the Form Controls section, click.On the Ribbon, click the Developer tab.When the box is checked, the data for that region will appear in the Next, you'll add a check box to the left of each region name in the Copy the formula across to cell H9, and then copy down to row.In cell C9, type this formula: =IF($A9=TRUE,C3,NA()).Otherwise, it will show #N/A, and the series will be omittedįrom the chart, because #N/A values are not plotted in an Excel chart.Ĭhart data range, shown below, is in cells B8:H11įollow these steps to create the headings and data for the duplicate data range:.Range, formulas will show the series' data, only if the check box Instead of using the original data range to create the chart, formulas are used toĬreate a duplicate range, linked to the original data. In this example, the original data for the Microsoft Excel chart is in cells B2:H5 Who creates time-saving Excel charting utilities. Note: This tutorial is based on a technique that I learned from Jon Peltier, People can click the check boxes, to quickly show or hide region data in the interactive chart. It works best for small to mid-sized tables. There is no programming required for this technique, and More Chart Tutorials Show Chart Series With Check BoxesĪdd check boxes on a worksheet, to control which series will be shown
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |