None of the above solutions are working to gain functionality of many of the Chart Tools>Layout tab features in an XLSM woorkbook created and open in Excel 2007 under Win7 Pro 64 Bit.
With a series sellected in a chart or not the "Data Table" in Labels, the "Chart Wall", Chart Floor" and "3-D Rotation" in Background and the ones I want to use "Lines", "Up/Down Bars" in Analysis are all grayed out.
Can't seem to figure it out yet.