Is it possible format the Spider Chart so that the negative area is always filled with red color and the positives with green.
For clarification:
The color filling is done manually and if the values change to much it doesn't fit.
Is it possible format the Spider Chart so that the negative area is always filled with red color and the positives with green.
For clarification:
The color filling is done manually and if the values change to much it doesn't fit.
Excel will do this pretty easily:
EDIT: Engineer Toast brought up a good point: make sure that your values series is the last one drawn (#4 in the samples below), otherwise it will be obscured by the other series. Excel draws the series in order, with the highest number (or lowest in the dialog box list) drawn last.
Here's some samples of how it could look: