Hello guys
i have two charts and i want to combine them. How you can see in the picture.
The first one is how it is and the second one is how i need it.
thank you very much for any help.
ps: i have no experience with vba
greetings from swiss
Hello guys
i have two charts and i want to combine them. How you can see in the picture.
The first one is how it is and the second one is how i need it.
thank you very much for any help.
ps: i have no experience with vba
greetings from swiss
Hello littlesonic and Welcome to Excel Forum.
This works with the sample shown in the screen shot. Please utilize the instructions for posting an Excel file (yellow box at top of page) in the future.
Note that I am not sure how applicable it may be to a more extensive data set.
Column A is populated using: =IF(OR(ROWS(A$1:A1)=1,A2=A1,A2=SUM(A1,1)),A2,IF(ROWS(A$1:A1)=COUNT(A$2:A$10)+SUMPRODUCT(--(A$12:A12=""))-1,A12,""))
Column C is populated using: =IFERROR(IFERROR(IF(MATCH(A13,C$2:C$5,0),A13,""),IF(AND(A13="",MATCH(SUM(A12,1),C$2:C$5,0)),SUM(A12,1),"")),"")
Column E is populated using: =IF(C13="","",INDEX(E$2:E$5,MATCH(C13,C$2:C$5,0)))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
hey
thanks for your effort. in the meantime i solved my problem by myself. anyway i will check out your way for the solution.
thanks and have some merry christmas.
Glad that you were able to find a solution. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day and a Merry Christmas.
Hey JeteMc
It`s done. Thanks for the support and merry christmas you too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks