Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 Custom Error Bars
I cannot seem to get custom error bars to work on charts in excel 2007. I
have a set of data, eight numerical y values, and each one has a different standard deviation. I plot a histogram and use custom error bars selecting +/- my deviations from the worksheet (which are approx 10% of numerical value so easy to see) and then click ok but nothing appears on my chart just two circles (doing the same in excel 2003 works fine, I see them fine). If I create the error bars in excel 2003 and open them in 2007 they appear and when I go into custom error bars the correct worksheet cells appear, however if I click ok they dissapear (clicking cancel they remain). Its infuriating! Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Custom autofilter Bug In excel 2002 | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Custom Lists in Excel | Excel Discussion (Misc queries) |