I am trying to reproduce a dot and reference line plot in Pyramid.  I know what I'd like to do and am having trouble implementing it in Pyramid.  I've attached the image of the chart which was prototyped in a different tool.  In the example above, the year is a dimension & placed on rows. I have created a dynamic reference line in the prototype where the PCTLs (individual data items) have been associated with each reference line.  I could have also done a dual axis chart where I pivoted the columns for the PCTLs into one data item to then have the circle on one axis and the lines on another axis.  

However, when I try to do the above actions (tie ref lines to data items) or pivot the PCTL columns, it doesn't work for me. 

As a result I have two questions:

• Is it possible to create a reference line based on a data item (and not user input or constant)? 
• How would you create this chart knowing that:
  • Year is a dimension
  • Measures are listed below in the image
  • The layout needs to be horizontal for easier readability.
  • Dynamically sorted by value so that the position of the lines and dot change as the data changes.
  • The goal is a circle (dot) and line (not another shape)...preferably a reference line but a gantt line (something thin) could work. b

Thanks! 

Emily