Question description:
This user has given permission to use the problem statement for this
blog.
I'm looking to put error bars on several line graphs. I know that I can adjust the error bars by line series, but can I specify the error bar ranges by data point? If so, how?
Solved by M. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
17/08/2018 - 04:20
Hi
User
17/08/2018 - 04:20
Hey there
Excelchat Expert
17/08/2018 - 04:21
can you share the excel
Excelchat Expert
17/08/2018 - 04:21
and explain further what you r trying to achieve
Excelchat Expert
17/08/2018 - 04:23
are you there
User
17/08/2018 - 04:23
Sure, I'm trying to attach the file now
[Uploaded an Excel file]
Excelchat Expert
17/08/2018 - 04:24
got the file
User
17/08/2018 - 04:24
The graph labeled "Belief-Based 5-Class Model" is the one I'm working on
Excelchat Expert
17/08/2018 - 04:25
Belief-Based Subtypes 5-Class Model bar graph?
User
17/08/2018 - 04:25
Each data point in each of the line series on that graph has a different confidence interval that cannot be specified by a percentage. I need to add custom error bars to each of the data points...if this is possible
Excelchat Expert
17/08/2018 - 04:25
ok
Excelchat Expert
17/08/2018 - 04:25
go to design tab
Excelchat Expert
17/08/2018 - 04:26
under add elements -> error bar
[Uploaded an Excel file]
Excelchat Expert
17/08/2018 - 04:27
selct custom
[Uploaded an Excel file]
User
17/08/2018 - 04:28
So I see I can do that, but I then seem to only have the option of adding error bars based on line series and not based on data point
Excelchat Expert
17/08/2018 - 04:28
the error data is the same for all the bars
Excelchat Expert
17/08/2018 - 04:29
1 mean for a given series the same
Excelchat Expert
17/08/2018 - 04:29
so 1st select a series ...then under design ->add elements ->error bar
Excelchat Expert
17/08/2018 - 04:30
so you can keep repeating that for each of the series I/C ,P/U
Excelchat Expert
17/08/2018 - 04:30
and so on..
User
17/08/2018 - 04:30
Each of my data points in the series I specify come from three different scales, with different means and different confidence intervels. Can I specify the error bars by data point only?
Excelchat Expert
17/08/2018 - 04:32
no not for each data point. for a given series you can specify
User
17/08/2018 - 04:32
okay thanks, that's all I was looking for
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.