| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Diagonal error lines in a scatter?
Sweet. Thanks
On Jul 22, 9:59 pm, "Jon Peltier" wrote: http://peltiertech.com/WordPress/200...two-xy-series/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. -http://PeltierTech.com _______ wrote in message ... I have a scatter with 2 series. Series 1 plots "Original GM%" vs "Original Sales". Series 2 plots "New GM%" vs "Sales At New Price". The two series have the same number of points; in each series, a point represents a customer. So every company has two points on the chart, one in series 1 and one in series 2. Is there anyway to automatically connect corresponding points in the two series? I know I can use error bars if only the GM changes or only the sales changes (that is, if a company's point in series 2 is vertically or horizontally aligned with it's point in series 1). But what if a company's sales and GM change - that is, if that company's point moves down and to the left (for instance)? Is there a way to draw that line? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need diagonal lines behind printed cells. | Excel Discussion (Misc queries) | |||
| Drawing Diagonal Lines "Refresh" problem - Any suggestions | Excel Discussion (Misc queries) | |||
| How do I add median lines to a scatter chart? | Charts and Charting in Excel | |||
| Scatter Chart with Smoothed Lines | Charts and Charting in Excel | |||
| How do I place diagonal lines in a cell in Excel. | Excel Discussion (Misc queries) | |||
Hybrid Mode
