Forum Discussion

Varun_Aggarwal's avatar
Varun_Aggarwal
Copper Contributor
Jun 16, 2021
Solved

Line chart

I am stuck with a graph that I am trying to create. I want to create a Profit and Loss line graph (with markers) of a stock that I have recently bought. Y-axis: Profit and Loss amount X-axis: Diffe...
Charting
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Jun 17, 2021

    Varun_Aggarwal The data in you picture doesn't seem to correspond with the graph, but perhaps the attached file has what you asked for.

    First add a column with the P&L figure, only for the row with the current price. All others need to be #N/A.

    Then create a scatter chart and add vertical error bars for the "current price" series as described in the article referred to by StoneKiwi 

    Now select the P&L series and change the chart type to a line.

Varun_Aggarwal's avatar
Varun_Aggarwal
Copper Contributor
Jun 17, 2021

StoneKiwi Thanks for your reply. Basically, as I have mentioned in my mail, this is a Profit and Loss (P&L) graph. I have attached the image that what I am looking at.

 

X-axis (horizontal) - Stock Price Range

Y-axis (vertical) - P&L amount

X-axis (horizontal) - Current market price of the stock (depicting with a line).

 

Thank you once again for your support.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jun 17, 2021

Varun_Aggarwal The data in you picture doesn't seem to correspond with the graph, but perhaps the attached file has what you asked for.

First add a column with the P&L figure, only for the row with the current price. All others need to be #N/A.

Then create a scatter chart and add vertical error bars for the "current price" series as described in the article referred to by StoneKiwi 

Now select the P&L series and change the chart type to a line.

Resources