AJP Excel Information

Tips

A collection of useful excel related tips and frequently asked questions

• Setting custom error bar values via VBA in xl2007

• Setting data marker transparency via VBA in xl2007

• Removing automatic chart title via VBA in xl2007

• Shape Adjustment in xl2007

• Linking the chart title to a cell

• Make X axis labels display below negative data

• Selecting chart elements using the cursor keys

• Changing name of embedded chart

• Displaying Y axis values on both sides of plot area

• Displaying Y axis values on the right of the plot area

• Plotting bar chart categories in reverse order

• Displaying the secondary X axis

• Line chart marker variations

• Installing Add-In  xl2007

• Mimic 2007 Conditional Formatting Icons

• Features deprecated in xl2007

Last updated 1st May 2010