Expert Zone
XLSX + XLS repair tool
HomeExpert ZoneAndy Pope

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.

This website uses cookies to manage sessions, forms, statistics and others. More information.