How do i plot two series of data both in accending order on a line
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. |
How do i plot two series of data both in accending order on a line
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. |
All times are GMT +1. The time now is 09:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com