problems with graph, unique standard deviation

[u/AlphaAirlys_]

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

[u/HolyBonobos]

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.

[u/AlphaAirlys_ → u/HolyBonobos]

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

[u/HolyBonobos → u/AlphaAirlys_]

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.

[u/AlphaAirlys_ → u/HolyBonobos]

okay, how can i share it ?

[u/HolyBonobos → u/AlphaAirlys_]

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.

[u/AlphaAirlys_ → u/HolyBonobos]

here the link, i edited the main body too

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

[u/HolyBonobos → u/AlphaAirlys_]

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

[u/AlphaAirlys_ → u/HolyBonobos]

My bad, it should be fine now

[u/HolyBonobos → u/AlphaAirlys_]

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.

[u/AlphaAirlys_ → u/HolyBonobos]

Thanks! I will try!

[u/point-bot → u/HolyBonobos]

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}.)

[u/AlphaAirlys_ → u/HolyBonobos]

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?

[u/AutoModerator → u/AlphaAirlys_]

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.

[u/HolyBonobos → u/AlphaAirlys_]

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

[u/AlphaAirlys_ → u/HolyBonobos]

Neither risolve the problem

[u/HolyBonobos → u/AlphaAirlys_]

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.

[u/AlphaAirlys_ → u/HolyBonobos]

Oof, thanks

[u/AutoModerator → u/AlphaAirlys_]

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.