Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
vertical vs horizontal error bars excel 2007
Where do you differentiate if you want vertical or horizontal error bars?
When I go to more options and select custom, it always chooses either vertical or horizontal for me (often incorrectly). Also, it sometimes says it is doing vertical error bars and then actually makes horizontal ones. Help anyone? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
vertical vs horizontal error bars excel 2007
This has bugged me as well; the new error bar interface is incomplete and
confusing. I don't know why they took it out of the Format Series dialog. If you go to Chart Tools Layout tab Analysis group Error Bars dropdown More Error Bars Options, it pops up a dialog that says "Format Error Bars", with only the Vertical Error Bars listed. When you dismiss this dialog, both sets of error bars appear, and you can click on either to refine their formats or data. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "chemheel00" wrote in message ... Where do you differentiate if you want vertical or horizontal error bars? When I go to more options and select custom, it always chooses either vertical or horizontal for me (often incorrectly). Also, it sometimes says it is doing vertical error bars and then actually makes horizontal ones. Help anyone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Error Bars Excel 2007 | Excel Discussion (Misc queries) | |||
cUSTOM error Bars in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Custom Error Bars | Excel Discussion (Misc queries) | |||
horizontal & vertical scroll bars | Excel Worksheet Functions | |||
Scroll bars (vertical and horizontal). | Excel Discussion (Misc queries) |