View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Charting a calculated number using the source data as the axis

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

"Ebreese" wrote in message
...
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.