Thanks Jon, This is an easy to understand method to work around the
limitations of Excel or should I say work within the framework of
Excel. I dont like having to duplicate the data in a separate table
but sometimes thats what you have to do...
Thanks Again
Robert

On Mar 10, 8:45*pm, "Jon Peltier"
wrote:
Robert -

Rather than type out an all-text answer, I wrote an illustrated blog post to
show just how easy this chart type is to create in Excel. It's a single
simple line chart, and all the hard work is done through careful arrangement
of the data. The blog post is located he

http://peltiertech.com/WordPress/200...main-effects-p...

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

"Robert H" wrote in message

...



I need to create a main effects chart which plots three factors (x
data) against two levels (y data).
example
http://www.itl.nist.gov/div898/handb...fs/dexmean.gif
This is simple enough using a line chart however I need to separate
the factors from each other, have them sit side by side rather than on
top of each other. So far the only way I have found to do this is to
make three charts, one effect each. *One chart with a large chart area
and a reduced plot area. The other two charts have the chat area
hidden (border and fill off) and lay over the first chart so that the
plot areas are aligned side by side. *This prototype is way too
cumbersome but I'm having a hard time figuring out how to do this in a
single chart.
Any help will be appreciated.
Thank
Robert- Hide quoted text -

- Show quoted text -