Complex Graphic Output

EE Pros,

Teylyn helped produce a fantastic 2 axis graphic for me.  I need one more part to this graphic.  I need to be able to return the value of "Sold" (y-Axis 1) and "Claimed" (y-Axis 2) and the intersection by date.  It's in the Series, but I don't know how to pull it out of the graphic.  For Example, with the graphic attached the number of "Sold" by the QDate should be 45667. And the "Claimed" by the CDate should be 454.  The data I'm trying to pull out fit in cells B32:C33.

Thank you in advance.

B.
C--Complex-Model-v7.xlsx
Bright01Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Ejgil HedegaardConnect With a Mentor Commented:
Use Index/Match to find the values.
For Q Alert - Sold the formula is =INDEX(Dataset1,1,MATCH($C$7,$D$5:$R$5,0))
See sheet for the others.
C--Complex-Model-v7.xlsx
0
 
Bright01Author Commented:
Ejgil Hedegaard,

THANK YOU!!!

PERFECT.

B.
0
All Courses

From novice to tech pro — start learning today.