View Single Post
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Al -

This is sometimes what Excel or MS Graph might do to be helpful. You're
plotting a single series, right? Double click the series, and on the
Options tab, clear the Vary Colors by Point checkbox.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

AlCamp wrote:

Hello all,
I'm actually working in Microsoft Access97, which uses MSGraph 2000 for
charting, so I thought this was really a "charting" question... not an
Access question.

I have an XY scatter chart (using just points... no X or Y error bars or
lines) all laid out just fine, but I have a couple of questions that would
make my work a lot easier.

When the data first displayed on the chart, every data point had a
different "style"... circles, triangles, x's, etc... I had to go into every
one individually and change them to a black dot at size 3.
Isn't there some way to tell the chart that I want that "style" for all
the datapoints at once??

Taking that same scenario, can I also globally change all the Data Labels
"style" (alignment, color, etc) all in one "fell swoop"??

Any help would be greatly appreciated...

Thanks,
Al Camp