Thread: How to chart a table to a specific format

Hi there,



I'm looking to generate a chart out of a table of data.



I want the Y-axis to show a percentage return on an investment.



On the x-axis I want to have a range of scenarios from a market average return of -40% to +40%. Obviously, I wish for 0% to sit in the middle of the x-axis.


I'd want to have 3 lines observable in the chart.



I'd be looking to build the above out of a table as shown in the attached file.



Does anyone have any advice as to how I would go about generating this?

Any advice gratefully received.

Attached is a basic line chart you may use as a starting point.

Thanks for that