Thread: scatter charts
View Single Post
  #1   Report Post  
Jon Peltier
 
Posts: n/a
Default

PMFJI, but a few pictures is worth a few thousand words. This page
illustrates the technique bj has suggested:

http://peltiertech.com/Excel/Charts/...nalChart1.html

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


bj wrote:

one of the ways to do this is to use multiple data series with if statements
which woul deither use the value of the point or a value outside the plot
range depending on the criteria. Then plot all of these secondary data sets
and format the symbols as wanted for each criteria.

"sroe9738" wrote:


Hi,

I am trying to create a simple scatter graph. The thing is, the requestor
wants the data markers to vary, based on a 3rd value.

Is there a way to do this? Any help would be appreciated.

Thanks,

Scott