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....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Overlay line graph points on bar graph 1
How do I adjust marker spacing in Excel scatter plot? 1
Flawed scatter plot function 2
Excel 2007: Lines not displayed on Scatter Plot 0
Excel 2007 Line Chart with Markers 1
Excel 2007: Lines not displaying on Scatter Plots 1
Excel 2007: Lines not displaying on Scatter Plots 0
Scatter Plot with color markers 2

Top