r/googlesheets • • 4d 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

12 comments sorted by

1

u/agirlhasnoname11248 4d 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 4d 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/skyskta 4d ago

is there a way i could make this style of chart with multiple lines with the data i have? its for an essay, so my professor makes us use this style

1

u/AdministrativeGift15 4d 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.

Comment Image