Charting a calculated number using the source data as the axis

E

Ebreese

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.
 
D

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

Editing a column chart for Variance Walk negative numbers 3
How do I put words as the Y axis values? 0
Charting on Primary & Secondary Axis - Zero Point Does Not Align 1
Overlaying 2 Data Series with Different Time (X) Axis 3
charting variable length line data 1
Plot a time series on the x-axis and categories on the y-axis 3
Changing the data label position below the chart axis. 2
Charting concatenated columns of data (from different dates)? 1

Top