SOLVED
Home

Error bars do not work with custom values - multiple series chart

%3CLINGO-SUB%20id%3D%22lingo-sub-997287%22%20slang%3D%22en-US%22%3EError%20bars%20do%20not%20work%20with%20custom%20values%20-%20multiple%20series%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-997287%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20bar%20which%20has%20multiple%20series.%20Think%20of%20it%20as%20a%20number%20charts%20combined%20together.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20table%20which%20has%20the%208%20series%20to%20be%20plotted.%26nbsp%3B%20For%20each%20series%20has%20a%20std%20deviation%20for%20each%20value.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEvery%20value%20is%20an%20average%20of%20a%20sample%20population%20and%20as%20such%20has%20a%20std%20deviation%20which%20I%20want%20to%20plot%20using%20error%20bar%20options%20of%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3E%3CSTRONG%3EThe%20bug%20i'm%20facing%20is%20that%20thee%20first%20series%20takes%20(plots)%20the%20custom%20error%20values%20while%20all%20other%20series%20show%20nothing%3C%2FSTRONG%3E%3C%2FEM%3E.%20I%20tried%20the%20view%2Fpaint%20options%20of%20the%20error%20bars%20but%20that%20did%20not%20help.%26nbsp%3B%20I'm%20convinced%20the%20problem%20is%20either%20a%20bug%20or%20some%20issue%20with%20data%20%22reading%22%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20excel.%20The%20first%20tab%20%22results%20Graph%2003%22%20has%20the%20bars%20I'm%20talking%20about.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20first%20first%20graph%20is%20bar%20grapth%20labeled%20%22Sorptivity%20summary%20of%203%20months%20specimens%20grouped%20by%20mixture%20design%22.In%20that%20graph%20there%20are%20the%208%20series%20plotted%20in%20it.%20Labeled%20in%20the%20table%20columns%20as%20A%2CB%2CC%2CD%20with%20post-fix%20H%20and%20F%20each.%3C%2FP%3E%3CP%3EFor%20each%20series%20i%20added%20in%20Column%20O%20a%20bunch%20of%20value%20which%20are%20the%20standard%20deviations%20representing%20the%20errors.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20need%20or%20want%20to%20use%20the%20std%20deviation%20or%20other%20features%20provided%20by%20MSFT%20error%20bar%20options.%20I%20want%20to%20use%20those%20custom%20values%20as%20both%20the%20plus%20and%20the%20minus%20ones.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESteps%20i%20use%3C%2FP%3E%3CP%3E1%26gt%3B%26nbsp%3B%20Add%20chart%20elements%20%26gt%3B%20Error%20options%3C%2FP%3E%3CP%3E2%26gt%3B%20I%20choose%20the%20series%3C%2FP%3E%3CP%3E3%26gt%3B%20for%20the%20series%20i%20choose%20%22Custom%22%20as%20the%20error%20amount%20and%20specifiy%20the%20%2B%20and%20-ve%20as%20the%20std%20deviation%20in%20column%20O.%26nbsp%3B%3C%2FP%3E%3CP%3ENothing%20happens%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-997287%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eerror%20bars%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-997315%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20bars%20do%20not%20work%20with%20custom%20values%20-%20multiple%20series%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-997315%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F452988%22%20target%3D%22_blank%22%3E%40haddad333%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20to%20restructure%20your%20data%20a%20bit.%20Let%20take%20A-F%20series%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20184px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155953iF8596D32D0BCAC68%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EA-F%20series%20takes%20entire%20column%20marked%20as%20(1)%20here%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155954i7FAAAA3E72160C3C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThus%20errors%20are%20also%20shall%20be%20defined%20for%20entire%20column%2C%20it%20is%20marked%20as%20(2)%20here%2C%20when%20it'll%20be%20shown%20-%20you%20have%20empty%20errors%20for%20empty%20values%20and%20some%20for%20non-zero%20ones.%20In%20your%20case%20error%20values%20were%20shifted%20on%20empty%20values%20and%20not%20shown%20together%20with%20them.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-997330%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20bars%20do%20not%20work%20with%20custom%20values%20-%20multiple%20series%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-997330%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20added%20a%20new%20column%20still%20the%20errors%20bar%20do%20not%20show.%26nbsp%3B%3C%2FP%3E%3CP%3EError%20bars%20are%20custom%20.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155955iC0DA7E69EAB1E704%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-997340%22%20slang%3D%22en-US%22%3ERe%3A%20Error%20bars%20do%20not%20work%20with%20custom%20values%20-%20multiple%20series%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-997340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F452988%22%20target%3D%22_blank%22%3E%40haddad333%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20the%20file%20I%20attached%20with%20previous%20post.%20You%20need%20to%20define%20entire%20column%20for%20error%20values%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20346px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F155956i542E298A3745B3F9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
haddad333
New Contributor

I have a bar which has multiple series. Think of it as a number charts combined together. 

I created a table which has the 8 series to be plotted.  For each series has a std deviation for each value. 

 

Every value is an average of a sample population and as such has a std deviation which I want to plot using error bar options of Excel. 

 

The bug i'm facing is that thee first series takes (plots) the custom error values while all other series show nothing. I tried the view/paint options of the error bars but that did not help.  I'm convinced the problem is either a bug or some issue with data "reading" . 

 

I have attached the excel. The first tab "results Graph 03" has the bars I'm talking about. 

The first graph is column chart labeled "Sorptivity summary of 3 months specimens grouped by mixture design".In that graph there are the 8 series plotted in it. Labeled in the table columns as A,B,C,D with post-fix H and F each.

For each series i added in Column O a bunch of value which are the standard deviations representing the errors.

 

I do not need or want to use the std deviation or other features provided by MSFT error bar options. I want to use those custom values as both the plus and the minus ones. 

 

 

Steps i use

1>  Add chart elements > Error options

2> I choose the series

3> for the series i choose "Custom" as the error amount and specifiy the + and -ve as the std deviation in column O. 

Nothing happens except for first series A-H

5 Replies
Highlighted

@haddad333 

You need to restructure your data a bit. Let take A-F series

image.png

A-F series takes entire column marked as (1) here

image.png

Thus errors are also shall be defined for entire column, it is marked as (2) here, when it'll be shown - you have empty errors for empty values and some for non-zero ones. In your case error values were shifted on empty values and not shown together with them.

 

 

Highlighted

@Sergei Baklan I added a new column still the errors bar do not show. 

Error bars are custom . 

 

clipboard_image_0.png

Highlighted
Solution

@haddad333 

Please check the file I attached with previous post. You need to define entire column for error values

image.png

 

Highlighted
Highlighted
Related Conversations
MSTeams Groups in outlook with macros disabled
ReadyorNot in Microsoft Teams on
0 Replies
Unknown Login Error
Alex_P3462 in Microsoft Teams on
0 Replies
Spelling Pop-Up Stuck on SharePoint List
aricornish in SharePoint on
0 Replies
Problem with OneDrive
esholder in OneDrive for Business on
5 Replies