Solved Problems with flat line on chart *time sensitive*

Conncast

New member
Joined
Feb 10, 2024
Messages
2
Reaction score
0
Points
1
Excel Version(s)
365
Hello, I am new to excel and am having an issue with an assignment, I need to graph a few elements and then adjust the graph for a sensitivity test, however the third dataset is only showing a flat line, I have
Reformatted the column
Redone the column
Added the pickers to an axis
and tried switching graph types and switching back

All to no avail, maybe somebody here could tell me what I am doing wrong? I have asked friends family and professionals about this and nobody can give me a satisfactory answer

It is worth noting that the profit line (the flat one) can be on its own separate chart for this assignment, but the data must be anchored to some variables located in the bottom left of the sheet. I am going to try attaching the file, it is not huge, just a simple analysis
 

Attachments

  • Mrs. Plum.xlsx
    17.4 KB · Views: 4
You're using the function IMSUB in that column (G) which is for displaying the difference between complex numbers.
2 things: (a) these numbers aren't complex and (b) the result of such a formula is text, not numeric.
Try replacing:
=IMSUB(F2,E2)
with:
=F2-E2
and copy down.
 
You're using the function IMSUB in that column (G) which is for displaying the difference between complex numbers.
2 things: (a) these numbers aren't complex and (b) the result of such a formula is text, not numeric.
Try replacing:
=IMSUB(F2,E2)
with:
=F2-E2
and copy down.
Thank you so much, that solved the problem, guess I was too fixated on the formulas from other projects!
 
Back
Top