PRobinson87
New Member
- Joined
- Jan 22, 2014
- Messages
- 8
Good Morning,
For work, I am trying to graph profitability by state (could be product line, customer, etc) with Net Sales on the X axis and Operating Income on the Y. When trying to graph this in excel, it treats the selected data as two seperate series and doesn't plot based on the values. Is there a way to correct this?
EX:
State Sales OI
FL 100 10
IL 10 -10
IN -20 -50
So FL should be at (100,10), IL at (10,-10) and IN at (-20,-50).
Please help, I'm ready to tear my hair out
For work, I am trying to graph profitability by state (could be product line, customer, etc) with Net Sales on the X axis and Operating Income on the Y. When trying to graph this in excel, it treats the selected data as two seperate series and doesn't plot based on the values. Is there a way to correct this?
EX:
State Sales OI
FL 100 10
IL 10 -10
IN -20 -50
So FL should be at (100,10), IL at (10,-10) and IN at (-20,-50).
Please help, I'm ready to tear my hair out
