Hello,
Is there some way to assign custom error bars to many different data series on a chart all at the same time? I will try to describe what I mean with a picture:
So the picture has three data series (types 1, 2, and 3) all plotted against time (day). Below the means are the standared deviations corresponding to each point above.
I want to use the standard deviations as the magnitude of the error bars. In my actual workbook I many several more series and it has become difficult to add the error bars to each data series individually. If possible I would like to tell excel that for a particular chart it should look to the corresponding cells below for error bars for all the series on the chart.
Thank you very much,
-DanExcel
Is there some way to assign custom error bars to many different data series on a chart all at the same time? I will try to describe what I mean with a picture:
So the picture has three data series (types 1, 2, and 3) all plotted against time (day). Below the means are the standared deviations corresponding to each point above.
I want to use the standard deviations as the magnitude of the error bars. In my actual workbook I many several more series and it has become difficult to add the error bars to each data series individually. If possible I would like to tell excel that for a particular chart it should look to the corresponding cells below for error bars for all the series on the chart.
Thank you very much,
-DanExcel