| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| charting extreme number differences on x-axis | Charts and Charting in Excel | |||
| Excel Charting: Multiple data series on two axis instead of one? | Charts and Charting in Excel | |||
| Y Axis Source Data | Excel Discussion (Misc queries) | |||
| Formatting X Axis Source Data | Charts and Charting in Excel | |||
| Multiple rows of data on a single axis (charting) | Charts and Charting in Excel | |||
Linear Mode
