Just use =INDEX(charts, neighbor_number) pattern. left1, left2, left3: are the the neighbors to left.Use =INDEX(charts, linked_cell_for_scrollbar) mid.chart: refers to the chart that goes in the middle.Now that we have neighbor numbers and charts range (from step 1), we can create 7 named ranges, one per chart. Step 4: Create 7 named ranges, one per chart cell If you need some help, here is a demo of how the neighbor numbers: We can calculate the neighbor numbers from a given chart number n using simple formulas. Tip: If you can’t tell your developer ribbon from oven mitten, check out this excellent guide on Excel form controls.įor our ICST to work, we need to show selected chart in the middle and the neighbors to left & right. Right click on the control to set its limits from 1 to 7 and link it to a cell. Using Developer Ribbon > Insert, add a scorllbar form control to your worksheet. ![]() Note: While this example shows how to do the ICST (Interactive Chart Slider Thingy, keep up) with 7 charts, you can apply this idea to any number of charts.Įxactly what it says on the box. ![]() Select a range of cells and resize them so that each cell can accommodate one chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |