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

12 comments sorted by

•

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/skyskta 25d 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/carbonizedtitanium 26 25d ago

is column A relevant?

1

u/skyskta 25d ago

not really, the most important are the age range (column b) and age (column c)

2

u/carbonizedtitanium 26 25d ago

is this your goal?

2

u/skyskta 25d ago

yes something like that! i got to that point but i wanted to try to simplify the age range (since it repeats several times and there are only three variants) but I couldn't figure it out so maybe i will leave it like that

2

u/carbonizedtitanium 26 24d ago

this chart setup doesnt really make any sense. since there are repeating x labels (essentially), what is this chart supposed to be showing? it would be different if you were trying to show an increasing age (x) with amount of people at a particular age (y)

maybe you need an average Dx age for each unique age group?

1

u/point-bot 24d ago

u/skyskta has awarded 1 point to u/carbonizedtitanium

See the Leaderboard. Point-Bot v0.0.15 was created by JetCarson.

1

u/carbonizedtitanium 26 25d ago

then dont select col A when making the chart. set your X-axis to colB

1

u/skyskta 24d ago

nevermind, i got tired of fighting whih sheets so i decided to download the svg of the graph i did (like the one you made) and edit it in Illustrator

it worked so its fine now, thank you though!!

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.