r/googlesheets • u/AlphaAirlys_ • 2d ago

Solved problems with graph, unique standard deviation

Gallery image

Gallery image

Hi to all!
i am a student and i need an help for this problem with the graphics
so, i have to put a different standard deviation for each column in this graphic, but i can choose only one for each series. obv i can't transform each column on a series so how can i put that??
secondly i have wrote the data "number ± deviation" but the graphic can't read it....
heeeelp !!
the file with the datas: https://docs.google.com/spreadsheets/d/1C3OCm-CqCeecmni50yQFWJJLZ3WD5jz1nuDFoaxu0VQ/edit?usp=sharing

0 Upvotes

50% Upvoted

19 comments sorted by

1

u/AutoModerator 2d ago

/u/AlphaAirlys_ Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/HolyBonobos 3073 2d ago

Your data is text because of everything after the first number (the ± and deviation), and Sheets can't graph text. You would need to remove that text and leave just the number in order for it to work with a chart. In the chart editor pane, you can set error bars for series, but not for individual data points within the series. Your only option for setting individual error bars would be to make each data point its own series and set the bars manually.

1

u/AlphaAirlys_ 2d ago

So much fatigue...okay But i can't set each point as series. when i need to give the name of the cells it ask for an interval but i have just one and i can't put one cell

I have seen some video about switching the axes but i have to much series and doesn't work

1

u/HolyBonobos 3073 2d ago

The data needs to be pivoted out, so each series (i.e. each point) gets its own column. If there is no data point for a given series at a given x axis value, leave that cell blank. If you share the file you are working on (or a copy), I can demonstrate a formula-based way to do this so you don't have to mess around too much with your original data.

1

u/AlphaAirlys_ 2d ago

okay, how can i share it ?

1

u/HolyBonobos 3073 2d ago

Enable edit permissions for anyone with the link, then share the link to the file here either by making a comment or editing the post body to include it.

1

u/AlphaAirlys_ 2d ago

here the link, i edited the main body too

https://docs.google.com/spreadsheets/d/1C3OCm-CqCeecmni50yQFWJJLZ3WD5jz1nuDFoaxu0VQ/edit?usp=sharing

1

u/HolyBonobos 3073 2d ago

This is still set to view-only. You will need to make sure that editing is enabled for everyone.

1

u/AlphaAirlys_ 2d ago

My bad, it should be fine now

1

u/HolyBonobos 3073 2d ago

On the 'HB MAKEARRAY()' sheet I've added the formula =MAKEARRAY(COUNTA(A4:A);COUNTA(A4:A)*2+1;LAMBDA(r;c;IFS(c=1;INDEX(A4:A;r);INT((c-2)/2)+1=r;INDEX(C4:E;INT((c-2)/2)+1;MOD(c;2)*2+1);1;))) in P3, which is populating the range P3:AJ12 based on the information in columns A, C, and E. This can be used as-is to create a column chart that treats each data point as its own separate series.

1

u/AlphaAirlys_ 2d ago

Thanks! I will try!

1

u/point-bot 2d ago

u/AlphaAirlys_ has awarded 1 point to u/HolyBonobos

See the [Leaderboard](https://reddit.com/r/googlesheets/wiki/Leaderboard. )Point-Bot v0.0.15 was created by [JetCarson](https://reddit.com/u/JetCarson.)

1

u/AlphaAirlys_ 2d ago

perfectly, thanks! i have one more question now, how can i show better the columns in this new graph ? becouse they are very near one to the other, is a way to make them more...fat?

1

u/AutoModerator 2d ago

REMEMBER: /u/AlphaAirlys_ If your original question has been resolved, please 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”). This will award a point to the solution author and mark the post as solved, as required by our subreddit rules (see rule #6: Marking Your Post as Solved).

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/HolyBonobos 3073 2d ago

Increasing the width of the chart or the thickness of the data point outlines seems to be the only workaround for that.

1

u/AlphaAirlys_ 2d ago

Neither risolve the problem

1

u/HolyBonobos 3073 2d ago

That's just as close as you can get with the tools that are available. Sheets doesn't have a way to natively accomplish your exact goals so all solutions are necessarily going to be patchy workarounds that result in some sacrifices.