LinkBack URL
About LinkBacks
Hello everybody
how can only A & B to be shown in horizontal axis , when I choose product1 in combo box AND how it is possible to do the same pattern with C & D in product2 and A,B,C and D in all products as well?
Hello everybody
how can only A & B to be shown in horizontal axis , when I choose product1 in combo box AND how it is possible to do the same pattern with C & D in product2 and A,B,C and D in all products as well?
In name manager define range.
As per selecting product in "chart" sheet, accordingly change in formula sheet.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
would you please write the formula??
Can Anyone Help Me?
Try in formula sheet
B9Formula:
Please Login or Register to view this content.
Drag towards the cell
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
hi friend ....i tried it but it didn't work , could you please do it on the sent file ?
Please check the attached file.
thanks for your attention friend
your sent formula worked on product1&2 but not in "all products" ... (cuz nothing is shown in all products )
and my next question... is it possible in product1(also product2 and all products) ,a & b column fill the whole horizontal axis?
Check the attached file.
For all product you need to change below formula in formula sheet
C9Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Use this array formula (CTRL+SHIFT+ENTER to activate the array, not just ENTER) in
B9 =IFERROR(INDEX(data!$A$1:$A$4,SMALL(IF((data!$C$1:$C$4=$E$1)+(data!$D$1:$D$4=$E$1),ROW(data!$A$1:$A$4)-ROW(data!$A$1)+1),COLUMNS($B$9:B9))),"") then drag to right
and in
C9 =IFERROR(INDEX(data!$B$1:$B$4,SMALL(IF((data!$C$1:$C$4=$E$1)+(data!$D$1:$D$4=$E$1),ROW(data!$A$1:$A$4)-ROW(data!$A$1)+1),COLUMNS($B$9:B9))),"") then drag to right
See in attach.
hi shukla.ankur and Indi_Ra tnx for reply it was very practical..
i have another question ..is it possible in product1 or product2 , diagram columns (a&b / c&d) fill the whole axis(chart)?
helloooooooooo
is my last question really possible or not ?
friends i got the answer so i'll share it maybe someone find it useful..
do you think it is possible to the same by define name (formulas tab)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks