Charting a calculated number using the source data as the axis



I would like to chart the result of a series of calculations. I am
calculating net debt to ebitda and the result will be 2.0, 2.5. etc. I wish
to plot the result but show the original numbers used for the axis. In other
words I want net debt to be one axis and ebitda the other with a line
representing the result of net debt / ebitda (2.0, 3.0, etc.).
Thanks for assistance.



David Biddulph

Select your data range including your "net debt" and "ebitda" columns, then
Insert Chart, and use the XY chart type.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Source data values for chart to involve a calculation 2
data source for chart 1
Chart Source Data 5
Chart data source 6
Source Data in Charts 1
Chart Data Source 1
chart source data 1
Chart Data Source 3