I have started a spreadsheet to show weigh in date, current weight weekly and the goal weight. I want a simple line graph showing progress to the goal but nothing I do works.
I want this look.
[Re-Titled by Moderator]
iPad, iPadOS 18
Hi kmcfarlen,
Your screenshot shows some weights in Column B (Current Weight) with the Decimal Separator as comma(,) and some with Decimal Separator as dot (.)
Those differences could be confusing Numbers.
Decimal Separators (comma or dot) are Region specific and can not be mixed.
Regards,
Ian.
You could also consider a 2D Scatter Chart, especially if you know your measurement intervals might be uneven, i.e. you forget to weigh on a certain day.
You add the connection lines by clicking the series in the chart and choosing Curved or Straight Connection Line in the Style tab.
Note that with 2D Scatter you do not want the first column to be defined as a Header Column.
SG
One way is to add a reference line.
For a Line chart make sure the first column in your table is defined as a Header Column.
SG
Why is my weight loss chart not showing progress graph?
