If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Ungrouping columns
I was wondering if there was a way to ungroup a column in
a bar graph from the others so I can put individual error bars on it. I can get error bars but it will put the same ones on all in that same group and that's not accurate for what I need. The way I have to have it set for presentation I can't do it any other way. If anyone can help it would be appreciated. |
#2
|
|||
|
|||
Ungrouping columns
Troy -
You can put the error bar values into the worksheet, different values for each point, then in the Error Bars dialog, use the Custom definition to select the range containing these values. You can also specify different positive and negative errors. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Troy wrote: I was wondering if there was a way to ungroup a column in a bar graph from the others so I can put individual error bars on it. I can get error bars but it will put the same ones on all in that same group and that's not accurate for what I need. The way I have to have it set for presentation I can't do it any other way. If anyone can help it would be appreciated. |
Thread Tools | |
Display Modes | |
|
|