Exclusive articles from Andy Pope
We are glad to share these articles written exclusively for us by Andy Pope with you. Our aim is to give you an extra bonus to our ExcelFIX file repair software. We hope you will find them helpful.
Selecting chart elements using the cursor keys
You can use the cursor keys to cycle through the elements in a chart. The up and down keys move through the main elements whilst the left and right can be used to move through the items in a element.
How to Vary the Built-in Line Chart Markers
On first inspection the shapes of the built in line markers appear to be very limited.
Formatting 'Invert if Negative' for Column and Bar Charts
Both column and bar charts give you the option to invert the area colour of any bar that has a negative value. What is not clear though is how to control the colour used for the negative bars.
