ISTR having problems finding the X error bar interface in 2007. Now of
course it seems obvious where it is, but when I first was hunting for it,
this whole discoverability thing was a myth.
When you add error bars from the control on the ribbon, the chart adds both
X and Y error bars, if it's an XY chart. Sometimes the X error bar values
are too small, and you don't see them or can't select them. But you can get
to them from the chart element selector dropdown thingie (forget what it's
called, and 2007 is only on my backup laptop downstairs). I also think you
can get to the X error bars from the Y error bar dialog, or maybe they're
tabs on the same dialog.
This is another way in which they've completely hobbled the charting user
interface. I'm in the process of designing an alternate Excel 2007 (and
might as well do 2003) charting interface, with my own usable dialogs. Maybe
it will be ready after a few weeks of nighttime hacking.
- Jon
