Spreadsheet: 128494d1321010613-chart-with-scrollbar-that-offsets-the-period-can-it-have-event-as-well-800486
Sheet: Sheet1

 |  | X Data |  | Event
 | 1 | 0.6043179644411364 | Event 1 | 1 | 1 | Start Period
 | 2 | 0.01826926008205376 |  | #N/A | 10 | Number of Period
 | 3 | 0.3914648658499972 |  | #N/A
 | 4 | 0.7455091128225124 |  | #N/A |  |  |  |  |  |  |  | The scroller is linked to $E$2
 | 5 | 0.2140586298944847 | Event 2 | 1
 | 6 | 0.03886579373377988 |  | #N/A
 | 7 | 0.2700218594521448 |  | #N/A
 | 8 | 0.05374327951415836 |  | #N/A
 | 9 | 0.7818097085492506 | Event 3 | 1
 | 10 | 0.7222092621895251 |  | #N/A
 | 11 | 0.1862255633249461 |  | #N/A
 | 12 | 0.2903190142957309 |  | #N/A
 | 13 | 0.1921009983727711 | Event 4 | 1
 | 14 | 0.392966618984571 |  | #N/A
 | 15 | 0.2942266474717151 |  | #N/A
 | 16 | 0.1689664197139679 |  | #N/A
 | 17 | 0.388269610879043 |  | #N/A
 | 18 | 0.5649100430814453 |  | #N/A
 | 19 | 0.1505947028745201 |  | #N/A
 | 20 | 0.7596385306617164 |  | #N/A
 | 21 | 0.5790712287161555 |  | #N/A
 | 22 | 0.02759882136235277 |  | #N/A
 | 23 | 0.01708619966651113 |  | #N/A
 | 24 | 0.7726285248057683 |  | #N/A
 | 25 | 0.153803717450166 |  | #N/A | The chart is a standard chart. The Y axis has had the Minimum and [NAME] values
 | 26 | 0.2753706780806114 |  | #N/A | set in order to stop the scale jumping.
 | 27 | 0.584491029684752 |  | #N/A
 | 28 | 0.4554641339489049 |  | #N/A | The data is set to reference Named Ranges
 | 29 | 0.4823211121946205 |  | #N/A
 | 30 | 0.2447044633677603 |  | #N/A | SCROLL_LABELS
 | 31 | 0.2115963347737411 |  | #N/A | SCROLL_DATA
 | 32 | 0.6566654129114675 |  | #N/A
 | 33 | 0.4800818035216068 |  | #N/A |  |  |  |  |  |  |  | This screen shot shows
 | 34 | 0.6524539857002545 |  | #N/A |  |  |  |  |  |  |  | the axis labels and Values
 | 35 | 0.7196551621988079 |  | #N/A |  |  |  |  |  |  |  | set to reference named ranges
 | 36 | 0.702409554491694 |  | #N/A
 | 37 | 0.1332962629258944 |  | #N/A
 | 38 | 0.4716597952087265 |  | #N/A
 | 39 | 0.3399103449022583 |  | #N/A
 | 40 | 0.02855888507864535 |  | #N/A
 | 41 | 0.6458719573759462 |  | #N/A
 | 42 | 0.07755498916723341 |  | #N/A
 | 43 | 0.2366102113992342 |  | #N/A
 | 44 | 0.717947751879017 |  | #N/A
 | 45 | 0.7339328038262174 |  | #N/A
 | 46 | 0.1231279772810339 |  | #N/A
 | 47 | 0.6089264770339989 |  | #N/A
 | 48 | 0.4359925509033353 |  | #N/A
 | 49 | 0.4519040216558367 |  | #N/A
 | 50 | 0.7184582819715395 |  | #N/A
 | 51 | 0.1478488424893499 |  | #N/A
 | 52 | 0.1925436879050063 |  | #N/A
 | 53 | 0.7406205150663265 |  | #N/A
 | 54 | 0.2031400663924607 |  | #N/A
 | 55 | 0.007653640356913805 |  | #N/A
 | 56 | 0.1354635452504741 |  | #N/A
 | 57 | 0.1565395049059617 |  | #N/A
 | 58 | 0.743539281450199 |  | #N/A
 | 59 | 0.06834472240401866 |  | #N/A
 | 60 | 0.1825803298672015 |  | #N/A
 | 61 | 0.490481225786113 |  | #N/A
 | 62 | 0.3851800454152915 |  | #N/A
 | 63 | 0.6222876235779836 |  | #N/A
 | 64 | 0.455812759376888 |  | #N/A
 | 65 | 0.7061714404171497 |  | #N/A
 | 66 | 0.2787779368267515 |  | #N/A
 | 67 | 0.4471791755261991 |  | #N/A
 | 68 | 0.7157444428015979 |  | #N/A
 | 69 | 0.6952343544921242 |  | #N/A
 | 70 | 0.06565706715118154 |  | #N/A
 | 71 | 0.1871180917538675 |  | #N/A
 | 72 | 0.2558407147323832 |  | #N/A
 | 73 | 0.7807209867355255 |  | #N/A
 | 74 | 0.4298723295955164 |  | #N/A
 | 75 | 0.3452105575659132 |  | #N/A
 | 76 | 0.08194745483387252 |  | #N/A
 | 77 | 0.1750155234619486 |  | #N/A
 | 78 | 0.5965175197967317 |  | #N/A
 | 79 | 0.1676235237025601 |  | #N/A
 | 80 | 0.7996878828428069 |  | #N/A
 | 81 | 0.3037589992056567 |  | #N/A
 | 82 | 0.1861927987546588 |  | #N/A
 | 83 | 0.768538169504242 |  | #N/A
 | 84 | 0.7824243011603251 |  | #N/A
 | 85 | 0.358123295552673 |  | #N/A
 | 86 | 0.497947222801249 |  | #N/A
 | 87 | 0.1087367310665471 |  | #N/A
 | 88 | 0.0724974045587297 |  | #N/A
 | 89 | 0.1660717712844384 |  | #N/A
 | 90 | 0.7599273844694914 |  | #N/A
 | 91 | 0.2159044748743455 |  | #N/A
 | 92 | 0.5669093409466976 |  | #N/A
 | 93 | 0.5856990375171698 |  | #N/A
 | 94 | 0.3193090561244574 |  | #N/A
 | 95 | 0.1033017982962557 |  | #N/A
 | 96 | 0.2960226675269919 |  | #N/A
 | 97 | 0.2076793825871283 |  | #N/A
 | 98 | 0.5882779881868437 |  | #N/A
 | 99 | 0.047183582992119 |  | #N/A
 | 100 | 0.3590301656006966 |  | #N/A