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. ArchivesCategories |