iworknumbers
I have a regular linear graph and have y values running from negative to positive, enabling x axis shows the line at the bottom of the graph. How is it possible to set it to show at zero, i.e. running from the origin (0,0)?
I also wonder how to change the width of the line? I can change the size of the "data symbol", but can't find for the line itself.
UPD: This is easily possible to do in Excel, so it will be surprising if Numbers can't do it.
You can do this with the IF function. The syntax is…
┌── IF function returns one of two values when upon an expression's evaluation.
│
│ ┌── string or calculation for cell to show upon TRUE/FALSE
│ │ strings should be inside double quotes "like this"
│ ┌────┴─────────┐
IF(if-expression,if-true,if-false)
└─────┬─────┘
└── the expression to evaluate
for example: to test if A1-A2 is negative, you can use (A1-A2)<0
the result must be a boolean
This results in the following calculation:
IF(Data::A1<0,"Negative","Positive")
Result:
An example for comparing a calculation in the if-expression:
┌── from table "Data" do A1-B1
│
│ ┌── is the result less than zero (i.e. negative)?
┌───────┴───────┐ │
IF((Data::A1−Data::B1)<0,"Negative","Positive")
└───┬────┘ └───┬────┘
│ └── if false, return "Positive"
│
└── if true, return "Negative"
Result:
However, this will return Positive even if the number is 0, so instead…
┌── from table "Data" do A1-B1
│
│ ┌── is the result less than zero (i.e. negative)?
┌───────┴───────┐ │
IF((Data::A1−Data::B1)<0,"Negative",IF((Data::A1−Data::B1)=0,"Zero","Positive"))
└───┬────┘ │ └─┬──┘ └────┬───┘
if true, return "Negative" ──┘ is equal to 0? ───┘ │ return "Positive"
└── return "Zero"
Took me a while, but I figured it out: The solution is to choose a scatter plot instead of a line chart.
Select Insert -> Chart -> 2D Scatter
Select the chart, then select Add Chart Data:
Now simply select your entire table, including the x axis. Numbers will figure out the rest and automatically select your leftmost column as the x-axis.
Finally, to make it look like a line chart, select the chart, then select the "Axis" tab in the inspector Chose Data Symbols: None and Connection Lines: Straight.
Result:
Best Answer
To answer the first part of your question, please see this Answer to Force line chart to show axis at point (0, 0)
Second part:
Select the line to highlight it. Then under Style in the Inspector the Connection Line and weight can be adjusted by point.