Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To plot 3 series each with 90000 data in single Line or XY chart. | Charts and Charting in Excel | |||
Accending order | Excel Discussion (Misc queries) | |||
Time Series Chart Data Plot Line ''Disappears'' When Y Axis Formating Is Changed | Charts and Charting in Excel | |||
Series order conflicts with line order | Charts and Charting in Excel |