Share via

Custom error bars for two sets of data on one graph

Anonymous
2017-12-03T00:20:35+00:00

My data is as follows 

Pirimicarb Rotenone
Log concentration Standard dev
-4.522878745 70.87 16.62245877
-5.522878745 65.85 15.79516126
-6.522878745 44.78 32.80349851
-7.522878745 21.95 30.49266215
-8.522878745 11.54 18.88309935
-4.558147824 99.05 2.652386897
-5.558147824 87.62 18.37223335
-6.035269079 72.72 26.55753799
-6.558147824 50.62 32.10264002
-7.035269079 23.04 19.86226689

I have plotted this on a scatter graph and entered the standard deviation as a custom setting

The error bars appear for one set of data but when I repeat the same process for the other no error bars appear 

I have many sets of data all along the same lines and the problem repeats 

What am I doing wrong? 

How do I fix it so error bars are present for both sets of data?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Andreas Killer 144.1K Reputation points Volunteer Moderator
2017-12-03T13:03:47+00:00

I selected 2.652386897 down to 19.86226689

And like Bernard Liengme below I can add custom error bats to the first data series but do not display on the second, when I ass other types (eg 10%) they do display 

You have to select the whole data for the error bars, that is the issue.

Here is my sample file:

https://www.dropbox.com/s/w4aj6ds2ag6gtgj/a2cd6342-57a6-4842-9cf1-dc5d99732aea.xlsx?dl=1

BTW, I've replaced the wrong screenshot above, now it reflects the download file.

Andreas.

Was this answer helpful?

1 person found this answer helpful.
0 comments

6 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2017-12-03T13:14:20+00:00

    Can you please send me sample file.

    @Bernard:

    Download link is in my previous post.

    I don't have Office 365, currently the last version I have is

    No issues.

    Andreas.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-12-03T12:36:22+00:00

    I selected 2.652386897 down to 19.86226689

    Although you've shown me its possible, I'm still having the same problem

    And like Bernard Liengme below I can add custom error bats to the first data series but do not display on the second, when I ass other types (eg 10%) they do display

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-12-03T12:16:23+00:00

    Andreas:

    Can you please send me sample file. I can add custom error bars to first data series but they do not display on the second one. I can add other types (e.g. 25%) and they do display.

    Email available at people.stfx.ca/bliengme

    Thanks

    Bernard

    Clearly there is a bug. This is my Excel version

    Was this answer helpful?

    0 comments
  4. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2017-12-03T09:18:03+00:00

    Maybe you did not specify the correct cells, because your data is shifted?

    EDIT: Wrong screenshot replaced

    Maybe this article helps:

    https://support.office.com/en-us/article/Add-change-or-remove-error-bars-in-a-chart-e6d12c87-8533-4cd6-a3f5-864049a145f0?omkt=en-001&ui=en-US&rs=en-001&ad=US

    Andreas.

    Was this answer helpful?

    0 comments