Forum Discussion
Excel Pivot Chart vertical dynamic line
Hello, This is my first post in this forum. I am using MS365 latest on Windows 10. I have created a Pivot Table and Pivot chart from a sample data set. All the data in the sheet is dynamic except ...
Hi,
Not sure I understand. If it's to be a vertical line, at which of the Strike entries in the horizontal axis should it be placed?
Also, where does this Spot value come from? Is it calculated from the raw data?
Regards
Not sure I understand. If it's to be a vertical line, at which of the Strike entries in the horizontal axis should it be placed?
Also, where does this Spot value come from? Is it calculated from the raw data?
Regards
JosWoolley Thanks for your response.
The horizontal axis will be the strikes against which vertical line will be drawn.
The Spot price(PT_PC!H4) will be dynamic as well. I have updated sheet with the to-be chart as well so that it explains what i want to achieve.