Hi,
I am having trouble making a chart do what I want it to do. I have an XY scatter of dollar values, with one range for negative values so I can format the line red and another range for positive values that I can format as green. So far, so good. I have added a 3rd range of values (blue markers in pic) to identify the profit level for each 1,000 increment in revenue and the breakeven) and then I added error bars.
What I have....
Here, I started manually drawing in lines to show what I am trying to accomplish.
How can I make this happen?
Thanks!
I am having trouble making a chart do what I want it to do. I have an XY scatter of dollar values, with one range for negative values so I can format the line red and another range for positive values that I can format as green. So far, so good. I have added a 3rd range of values (blue markers in pic) to identify the profit level for each 1,000 increment in revenue and the breakeven) and then I added error bars.
What I have....
Here, I started manually drawing in lines to show what I am trying to accomplish.
How can I make this happen?
Thanks!