Forum Discussion
Snoopdon
Jul 29, 2022Copper Contributor
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 ...
- Jul 29, 2022
Snoopdon I think what you want is an X-Y scatter plot. See attached
HansVogelaar
Jul 29, 2022MVP
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.
Snoopdon
Jul 30, 2022Copper Contributor
Ok, this one works also. Thanks, Don