Forum Discussion
kitpuos
Apr 15, 2023Copper Contributor
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 ...
JosWoolley
Apr 16, 2023Iron Contributor
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
kitpuos440
Apr 16, 2023Copper Contributor
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.