Hello
managed to put together a scrolling graph, where quota is shown at a stand still vs. sales ppl actuals.
i have highlighted in "yellow" where the scroll data is triggered from, however, i cant seem to remove the #REF that is show on the graph?
-if u scroll to the very right of the graph, it will show a #REF error.
can someone pls help me remove those; ive been at this for the past day+. thx you so much!!!!!
Last edited by jw01; 04-21-2011 at 02:17 PM.
You're getting the #REF because the row number exceeds the number of rows in the INDEX()
Increase the INDEX() size to accommodate max values
Last edited by Cutter; 04-21-2011 at 01:38 PM.
hello cutter,
thxs for your help, however, i want the entry to stop at 'van wicker'
i dont want to show any more data points after that person...can you help me with that? thxs alot!
jw01,
Is this a duplicate post? It looks like it is. http://www.excelforum.com/excel-char...croll-bar.html
If it is, please do not practice duplicating posts. It is against forum rules and is not fair to people trying to help you as they end up just wasting their time not knowing others have also helped you.
Last edited by NBVC; 04-21-2011 at 02:01 PM.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I have adjusted your INDEX() formulas row references to contain caps.
Thanks NBVC for pointing that out. I assumed someone with that many posts would be following forum etiquette.
hello guys
no, i did not mean to replicate two threads. when i initially posted my first thread, it showed an error on my explorer so i refreshed my screen and created another post; i then realized my first thread was created even though it showed an error - my apologies but i didnt know how to delete a thread. thxs
also, cutter, ive managed to insert a offset function so it doesnt show any blanks etc; however my graph is showing the initial "quota" and data for a single sales person, is it possible when i scroll that it shows more than one person? hope u follow, thxs
pls ignore my last thread, thxs cutter. i guess i didnt need the offset....very cool thxs!!!!!
Please, then update your other thread so that responder is not left hanging....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks