Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 78
  • Last Modified:

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
0
Bright01
Asked:
Bright01
1 Solution
 
Ejgil HedegaardCommented:
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now