Hi,
If you sort each product by it's sales figure then you will have a unique
SalesRep order for each series. So I don't see how you can also have Reps
sharing the one x axis.
You might want to consider a different chart type. Perhaps a Bump chart
where the vertical divides are the Product, Vertical scale sales and Reps as
lines.
http://www.processtrends.com/toc_bumps_charts.htm
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"MFM" wrote in message
...
I have multiple series of data to plot in a line graph that I want view
from
the lowest to highest. For example:
sales sold by REP AND product type & person. Each series represent a type
of product. the Vert scale is the number sold and the horz scale is the
rep
in order of rank from lowest to highest. Each series/product is
independant.
Can I do this?
Thanks.