How to Add Scroll Bars to Your Excel Charts

Chart is a very useful feature in Excel. Therefore, inserting scrollbar into charts can help you better analyze data.

If you need to input a bunch of data into one chart in Excel, you will certainly find that the chart is not easy to look at. And not we have found a new method of inserting scrollbar into a chart in Excel. Thus, you can review the chart more easily.

I. Add Bar Chart and Set Name

  1. Select the range that you will use to create a chart.
  2. Click the “Insert” tab in the ribbon.
  3. Then click the button “Column”.Create a Bar Chart
  4. And in the drop-down menu, click the chart type. Here we create a bar chart.
  5. Click “File” in the ribbon.
  6. And then click “Options”.Click File and Option
  7. In the new window, click “Customize Ribbon”.
  8. And then in the right part, check the option “Developer”.Add the Developer Tab
  9. Then click “OK”. If you have already added this tab, you can skip those steps.
  10. Click the “Developer” tab.
  11. In the developer tab, click the button “Insert”.
  12. And then click “Scroll Bar”.Click Scroll Bar
  13. Now you can drag your mouse and draw a scroll bar as your need.
  14. After you have created a scrollbar, right click it.Click Format Control
  15. In the new menu, choose “Format Control”.
  16. In the new window, input the minimum and maximum value.The Window of Format Control
  17. Now you need to input a cell link into the text box. You can set any of a blank as the link cell. And here we set it C1.
  18. Then click “OK”.
  19. Input the period that you want to show in a blank cell. For example, if you want to show 3 bars in the chart, you can input the number 3. Here we input it into the cell C2.
  20. Then click the link cell C1.
  21. Click the “Formulas” tab in the ribbon.
  22. Then click “Define Name”.Click Define Name
  23. Input the name of the first column into the text box. Here we input “Sales_Rperesentative”. If the name includes two words, you should add a “_” between the two words.
  24. And then input the formula into the “Refers to” text box:

=OFFSET(Sheet2!$A$1,Sheet2!$C$1,0,Sheet2!$C$2,1)

Sheet2 is the current sheet that you are editing. A1 is the first cell of the range. C1 is the link cell. And C2 is the cell show the period. And you need to change according to your actual situation. The OFFSET function here will return the reference in the text box.New Name of First Column

25. Next click “OK”.

26. Now click the “Define Name” once again.

27. In another “New Name” window, input the name into the text box. Here we input “DataNumen_Excel_Repair”.

28. And in the “Refers to” text box. Input this formula:

=OFFSET(Sheet2!$A$1,Sheet2!$C$1,1,Sheet2!$C$2,1)

You should also change it according to your actual situation.New Name of Second Column

29. And then click “OK”.

II. Set Series in Chart

  1. Right click the bar chart that you have created before.Select Data
  2. And in the new menu, then choose “Select Data” option.
  3. In the “Select Data Source” window, click “DataNumen Excel Repair”
  4. And then click the first “Edit” button on the left.
  5. Then in the text box of “Series values”, input this into it:

=Sheet2!DataNumen_Excel_Repair

Sheet2 is the sheet that you are now editing. “DataNumen_Excel_Repair” is the name of the second column. Here we add “_” between the words because we have added this in the Name in the previous part. In addition, you need to change the elements according to your worksheet.Input Series Values

6. And then click the button “OK”.

7. Now you will come back to the “Select Data Source” window. Click the second button “Edit” in the “Horizontal (Category) Axis Labels”.

8. Then in the “Axis Labels” window, input this formula into the text box:

=Sheet2′!Sales_Representative

Also you need to change the worksheet and the name.Input Axis Label Range

9. And then click the button “OK”.

10. Then continue clicking “OK” in the “Select Data Source” window.Click OK

Thus, you have finished all the settings. Now you can click the scroll bar and the category of bars on the chart will also change according to the number. You can also input the numbers directly into the link cell that you have set.The Result

What’s more, the total number of bars will remain 3 as you have set before. And you can also adjust the shape of scroll bar to make it more beautiful. As for the result, you can see the  video below:

You will find that the number on the link cell C1 will also change according to the scroll bar.

Software has Flaws and Excel is Hardly an Exception

Excel is now the most popular software in office. As a result, most of the work needs to use Excel to finish. However, it is still not perfect, like the other software. It will sometimes refuse to work, or you couldn’t open any Excel file. Besides, Excel is also vulnerable to virus and malware. And once the Excel corrupts, the disaster will leave you bewildered. Therefore, you should try to repair it as soon as you can. One of the best Excel recovery tool in the world is our software. It has perfect algorithm and is capable of retrieving almost all the lost data and information in the damaged files.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

7 responses to “How to Add Scroll Bars to Your Excel Charts”

  1.   אני מודה ללורד הוודו האמיתי והרב עוצמה על שהחזיר את המאהב שלי אליי.  הוא רק אמר לי לספק את הפריטים שהוא יצטרך כדי שהלחש יהיה מאוד יעיל ואני סיפקתי את הפריטים, הוא שאל כמה שאלות ואני הגבתי. אחרי שהוא קיבל את החפצים הוא אמר לי בעוד ארבעים ושמונה שעות (48 שעות) אני אתחיל לראות את התוצאה של הכישוף שהוא הטיל, וזה בדיוק מה שקרה, כל דבר שהוא אמר יצא בדיוק כמו שהוא אמר שזה יקרה לִהיוֹת. וודו לורד הוא איש אמיתי של המילים שלו.  פנה אליו כדי לפתור את הבעיות שלך אחת ולתמיד. 
      דוא”ל: voodooconnect60@gmail.com
      WhatsApp: +234 8097014925 

  2.   העולם צריך לדעת על מטיל הכישוף הגדול “ וודו לורד ” שיש לו את הפתרון המושלם למערכות יחסים, נישואים, בריאות, כספים ובעיות אחרות שמציקות לאנושות.  הסיבה העיקרית שהלכתי לאדון הוודו הייתה למצוא פתרון להחזרת בעלי ולהיכנס להריון היא כי בעלי עזב אותי כי לא יכולתי להיכנס להריון לאחר 14 שנות נישואים.  לאחרונה קראתי המלצות באינטרנט שכמה אנשים כתבו על לורד הוודו, ושמחתי מאוד והחלטתי לבקש עזרה.  הוא עשה עבודה נהדרת כדי לגרום לבעלי לחזור אליי ולבקש סליחה, כמה חודשים לאחר מכן נכנסתי להריון.  עכשיו אני אמא גאה לתאומים, ילד וילדה, ובעלי מעולם לא הפסיק לאהוב אותי וחיינו באושר רב ביחד.  אני לא יכול שלא לפרסם את שמו באינטרנט כי הוא עשה עבודה טובה בשבילי.  כל מי שצריך את עזרתו צריך לפנות אליו במייל [voodooconnect60@gmail.com] או להוסיף אותו בוואטסאפ [+234 8097014925] ניתן ליצור איתו קשר עוד היום כדי לפתור את הבעיות שלך ולהישאר מאושר לנצח.

  3.   הייתי כל כך מדוכאת ופגועה בחודשים האחרונים לאחר שאיבדתי את בעלי לאישה אחרת וגם מצבי הכלכלי החמיר שחשבתי שאצטרך להגיש בקשה לפשיטת רגל.  הייתי בחובות עצומים ולא ידעתי מה לעשות.  מתוך ייאוש מוחלט ומוחלט יצרתי קשר עם רבים מאותם אנשים כביכול שהבטיחו קסם שחור רב עוצמה.  אף אחד מהם לא עבד ואף אחד לא היה נפלא, מסביר פנים וחם כמו VOODOO LORD.  הוא בהחלט שונה משאר מטילי הקסמים, כשהוא אמר לי שהוא יכול לשמח אותי שוב, מיד הרגשתי תקווה וכוח.  הוא נושא אווירה של טוהר וכוח אלוהי.  ביקשתי את יכולות הקסם של וודו לורד ומיד הוקל לי שיש מישהו שיפתור לי את הבעיות שלי.  הכישוף שלו עשה פלאים ועכשיו אני חוזר עם בעלי ובעיות הכסף שלי נפתרו מעצמן לאחר הזכייה בלוטו.  אני לא יודע מה הייתי עושה בלי עזרתך VOODOO LORD, הנה כתובת האימייל שלו voodooconnect60@gmail.com  או WhatsApp +2348097014925 .  הוא יכול לעזור לך בכל מצב שתתמודד כמו שהוא עזר לי.

     

  4. Hallo Frënn, dëst ass mäi Zeegnes, ech sinn ee vun deene Leit, déi gesot hunn: “Ech wäert ni e Psychiker nennen oder e Magier oder eppes” fir mir ze hëllefen meng Probleemer ze léisen – op d’mannst all meng Léiftproblemer, awer ech krut bis de Punkt wou ech wousst datt ech e puer Orientéierung brauch, a frou ass et fir mech datt ech dëse Mann mam Numm DR OSITA fonnt hunn. Wann ech bal de Samuel an engem vun den Ouer vun domm Kämpf verluer (hien huet mat mir opgebrach), Ech geduecht ech verluer alles. Ech kräischen de ganzen Dag an ech mengen et wäert ni méi bei mech zréckkommen. Ech hunn esou vill Zeegnes iwwer den Dr OSITA Léift Zauber gelies, wéi hien hëlleft eng Ex-Meeschtesch zréckzebréngen. Ech schécken him eng E-Mail séier an och meng Léift Zauber zu mengem Mann zréck bannent 48 Stonnen wann ech agehalen. A wann ech a menger Verzweiflung war, huet hien net vu mir profitéiert. Dir hutt e ganz gudde Service gemaach fir eng Persoun déi an der richteger Nout ass. Ech weess net wéi Dir et gemaach hutt oder wéi dës Magie funktionnéiert, awer alles wat ech weess ass, et funktionnéiert !! Den David, mäi Mann an ech si frou zesummen, an ech wäert dem DR OSITA ëmmer dankbar sinn, schéckt him eng E-Mail fir all Hëllef, hien ass ganz kapabel an zouverlässeg iwwer E-Mailadress ze hëllefen:drosita20112@gmail.com oder kontaktéiert him op WhatsApp a Viber: (+447307347648), ech wënschen Iech alles Guddes.

  5. Men Who Regret Letting A Good Woman leave Share Their Breakup Stories

    he had A “Grass is often Greener” point

    due to throwawaysaddayz: It started as a tough but amicable breakup that I started. I felt I was not ready for a serious long term relationship and was getting ‘grass is greener’ feelings and romantic relationship was at a lull stage. It was my first alliance so I didn’t know what these feelings meant or how to navigate them. After a month I came running back to her (texting) to inquire about forgiveness and to ask if we can try again. After what seemed to be a hopeful few weeks of texting the proposal was ultimately rejected. In a wide number of words she said she was too hurt and the trust is too broken. My regret after the breakup stemmed from my feelings telling me all we really needed was time apart and that I took her without any consideration. That I didn’t actually do anything to fix matters when we were in a lull. That I didn’t actually relay how I was feeling. That love is not always like a Disney movie. That I couldn’t answer what people has that she doesn’t? So okay, consist of all mistakes I will live with. She has stuck true to no contact except for a few weeks when I broke contact, [url=htttps://www.linkedin.com/in/charmingdate]charmdate.com[/url] And I had hope of fixing things. Now I am the horrible ex who broke her heart and came crawling back only to be kicked to the curb. my wife kept her dignity. i haven’t. My attempt to fix things probably decreased her opinion of me. So now I guess it’s many many lessons learned. And i am aware its over. whilst still being I get shreds of hope. But I know it is considered to be over. And I know it probably wasn’t can be, And I know if I did get your ex-lover back it would probably be a disaster. And I am only feeling this kind of because I’m lonely. exactly what if? does not matter now it’s over. a lot more than during well over. She doesn’t care about you anymore and you don’t matter. She will hire a roofer soon and she will look back and be happy it never happened. and consequently so will I.

    most wives vs. adult males, according to BisexualsIckiest Dating Advice of YoreMen Regrets About the One Who Got AwaySecrets Men Keep that Women Don Know AboutDating Tips for Men, By WomenThings Women Notice When They Meet a GuyOnline Dating for Men Isn AwesomeThe hardest things for Men to Explain to WomenWhat Men Should Know About Women Healththey fell for someone elsewarning signs of a toxic partner.

Leave a Reply

Your email address will not be published. Required fields are marked *