Changing markers in Scatter PivotChart

A

Andre

Is it at all possible to do the following in a Pivotchart:

Change the "default" colours and markers used on the markers in a scatter
chart
Set a conditional formating of the markers based not only on below and above
0, as is currently the case.

What I want is e.g:

I use 2 fields as my Series (SurveyName, Survey Question) - IF the
surveyName = 2007ABC then all markers will be circles. THEN use Blue for the
first series, Red for the second etc.

Currently I am doing it manually everytime and then if you close the form
you LOOSE all setting...

This is annoying if you you have 30 serie points....
 
Top