That took me a little bit to figure out, your rework of my chart realy
helped. Labels are actually series data, and the separators are error
bars. Clever!
I'm adding a table for the Grand Mean that crosses the entire chart
and naming the source data to feed the chart page data table.

Later I might setup the tables to grow accordingy if I add factors but
I may find that I dont change it that much...
Thanks
Robert


On Mar 10, 8:04*pm, "Kelly O'Day" wrote:
Robert:

You want to make a horizontal panel chart. Here's a link to an Excel how-to.

http://processtrends.com/pg_charts_p...l_XY_chart.htm

If you run into trouble, send me the file and I'll try to make it for you.

Kelly

edit address and send to:

koday*at*processtrends*dot*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 -