How do i plot two series of data both in accending order on a line

[MFM]

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.

 

[Andy Pope]

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