How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Yegarboy Your Own Question

Yegarboy
Yegarboy, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 491
Experience:  Expert VBA Programmer.
Type Your Microsoft Office Question Here...
Yegarboy is online now
A new question is answered every 9 seconds

I am working on an excel dashboard. I have inserted excel

Customer Question

I am working on an excel dashboard. I have inserted excel charts except for the very last row where I have used the cells to add a table of data. I want to add a horizontal scroll bar to part of the table so it doesn't take up much room on the dashboard. I have tried everything. The table is 7 columns and 11 rows. I want the 1st column to be static with the next 3 showing and be able to scroll over to the next three columns by increments of one column at a time. I am new to this and may be way over complicating it but at this point i am very frustrated. Please help!
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Yegarboy replied 1 year ago.

Hi and welcome to JA!. In order to better assist you could you please upload your workbook to www.wikisend.com. After upload please provide me with the File ID number or Download Link.

This way I can perform the work for you :) If your Workbook contains Private data, please replace it will dummy values.

Customer: replied 1 year ago.
Okay, dummied it up and sending
Expert:  Yegarboy replied 1 year ago.
Ok
Customer: replied 1 year ago.
file ID 276430
Expert:  Yegarboy replied 1 year ago.
Ok, I have it. I read your request but could you explain how you would like to see it?
Customer: replied 1 year ago.
I want the clients column to be static with the next 3 columns showing at first with the option to scroll over to see the % Temp and additional opportunities coumns with a scroll bar or whatever is most effective
Expert:  Yegarboy replied 1 year ago.
I can Hide the column as you want but because of the location of the cells it hides half of the dashboard with it.
Customer: replied 1 year ago.

Can you think of another way to do this?


 

Expert:  Yegarboy replied 1 year ago.
I cant no. But maybe another Expert can, I will opt out and see :)
Expert:  Yegarboy replied 1 year ago.
See if this is ok. I hid your data and added a Listbox to scroll thru it.

http://wikisend.com/download/307540/Dashboard Dummied.xlsx
Customer: replied 1 year ago.
when I download and extract the file I don't see my spreadsheet?
Expert:  Yegarboy replied 1 year ago.
http://wikisend.com/download/478530/Dashboard Dummied.xlsx

Try this one. Remember to save it and Open with Excel. Sometimes the default program isnt triggered when downloading.
Expert:  Yegarboy replied 1 year ago.
Is it ok?
Customer: replied 1 year ago.
It's closer but what I wanted was the client column to be static (always be there, plus the first three columns always showing on the dashboard. so I would open the dashboard, see the client column and the first three columns. I would then be able to scroll through the next three columns , incrementing by one with it stopping at the end of the data. also need it formatted the same as the original one. I needed it very quickly so I just went to plan b.
Expert:  Yegarboy replied 1 year ago.
Ok,

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional