Line Chart Help

Aliros

Hello, SmartSheet Community! I am hoping someone out there can help me with a line chart.

Here is screen shot of my data -

This is a screen shot of the line chart I'm working with -

This is pretty close to what I want except that I want the data labels in the cart to be the "Day to Day" values, not the weight values. I also want the dates across the bottom. The weight on the vertical access is correct.

I know how to do this in excel (screenshot below of excel showing what I'm trying to get to get to in SmartSheet), but can't figure it out here. Can anyone help?

Amanda King

Assuming you have tried switching rows and columns option? If adjusting the options below do not help I have found that I have to change the way I have my data in the sheet itself.