Forum Discussion

Copper Contributor

Jul 29, 2022

Solved

Need help making chart from data taken on non-contiguous dates

I want to make a chart in Excel 365 for the weights of our two cats, Calvin and Hobbes. I am starting with data from our vet, who gave my wife a chart for each cat recently. Since we don't take both ...

Calvin and Hobbes Weight Tracking Spreadsheet.xlsx15 KB

Charting

excel

office 365

mtarler
Jul 29, 2022
Snoopdon I think what you want is an X-Y scatter plot. See attached
Calvin and Hobbes Weight Tracking Spreadsheet.xlsx15 KB

HansVogelaar

MVP

Jul 29, 2022

Snoopdon

You might want to connect the points instead of leaving gaps.

And change the horizontal axis to a text axis to display only the dates from the source.

See the attached version.

Calvin and Hobbes Weight Tracking Spreadsheet.xlsx15 KB

Snoopdon

Copper Contributor

Jul 30, 2022

Ok, this one works also. Thanks, Don

I'm curious, how did you connect the points?
Thanks,
Don

HansVogelaar
MVP
Jul 30, 2022
Snoopdon

In the 'Select Data' dialog for the chart, I clicked the button 'Hidden and Empty Cells'.

In the resulting dialog, I selected 'Connect data points with line'.

Finally, I clicked OK in both dialogs.
- Snoopdon
  Copper Contributor
  Jul 30, 2022
  Excellent! I never knew about that function. I've been using Excel for maybe 25 years or more and am always learning new features. Thanks for pointing that one out to me. I wish there were a way for me to accept TWO answers as the best because your answer is equally as helpful as the one posted by the other person.
  Don