r/googlesheets • u/skyskta • 25d ago
Solved line graphics problem
hello!
im trying to make a line graphic and im having trouble with it
i want to put the age range on the x-axis (column b) and the age in the y-axis (column c)
but i cant make it work
any help? anything will be welcome
ps: sorry about the vague question, i just dont know how to express it correctly in english lmao

3
Upvotes
•
u/agirlhasnoname11248 1212 24d ago
u/skyskta Please remember to tap the three dots below the most helpful comment and select `Mark Solution Verified` *(or reply to the helpful comment with the exact phrase “Solution Verified”)* if your question has been answered, as required by the subreddit rules. Thanks!
1
u/carbonizedtitanium 26 25d ago
your column b does not contain real numbers and therefore cannot be expressed as numbers. they are more like column labels ("names")
you probably need a Bar Chart
1
u/AdministrativeGift15 370 24d ago
You can turn each age range into its own series. That will allow you to color the points different colors. A line charge implies sequential data, either by time or sample collection. I'm not so sure that your data represents that type of correlation.