Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Does anyone have a template for creating a slip chart in Excel
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Does anyone have a template for creating a slip chart in Excel
Hi,
Can you provide a link to an example of what you mean by 'Slip Chart'? Cheers Andy Slip charts in Excel wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Does anyone have a template for creating a slip chart in Excel
I assume he means this:
http://www.noweco.com/qei/qeie10.htm not these: http://www.smycmarina.com/slipchart.html http://personalinjury.cprlaw.com/Cau...3-602-206.html If I interpret the first link properly, X is the predicted finish date and Y is the date at which the prediction was made. For each line on the chart, you need a column of predicted dates and prediction dates. Make an XY chart from the first pair of date columns, Double click the vertical axis, and change the scale so it plots in reverse order and the axis crosses at the maximum. Copy each successive pair of data columns, select the chart, and paste special as a new series with the X (category) data in the first column. If you're feeling advanced, you could check out the "Series with Distinct X Values and Shared Y Values" option on this page, since all the Y values are the same: http://peltiertech.com/Excel/ChartsH...lXYCharts.html Or you could try the Quick XY Chart utility: http://peltiertech.com/Excel/ChartsH...s.html#utility - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Andy Pope" wrote in message ... Hi, Can you provide a link to an example of what you mean by 'Slip Chart'? Cheers Andy Slip charts in Excel wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a template with excel | Excel Discussion (Misc queries) | |||
Using Packing Slip Template | Excel Worksheet Functions | |||
creating a chart template | Charts and Charting in Excel | |||
Creating a template in Excel? | Excel Discussion (Misc queries) | |||
is there a template for an electronic charge sales slip? | Excel Discussion (Misc queries) |