Try this:

Step Charts in Microsoft Excel
http://peltiertech.com/Excel/ChartsHowTo/StepChart.html

Line Chart vs. Step Chart
http://peltiertech.com/WordPress/lin...vs-step-chart/

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Mike wrote:
I have a statistical process control chart with upper and lower control
limits identified by a dotted line. Control limits are calculated based on a
certain amount of deviation from the mean. After 7 data points, a new mean
is calculated based on the next 7 data points and therefore new control
limits. The true way to illustrate this is to have a break in the dotted
control limit lines on the chart, but Excel slopes the line to the new
control limits. Is there a way to have a break between these control limit
lines? 3 sets of 7 data points are on the chart.