Try making the chart this way:

http://peltiertech.com/Excel/ChartsHowTo/StepChart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"MBush" wrote in message
...
The only way I've found of making a stairstep chart over time is to enter
the
the mean dosage value repeatedly for each day taken thus depicting a
stairstep of trial and errors to reach a stablized dosage to be taken.
For
each stairstep I want to have only one value shown or printed for each
stairstep (varies in length) instead of the same value repeated for each
day
(becomes unreadable). If you place the cursor anywhere on the stairstep
and
wait, a display appears on the screen with a single value for the
stairstep--any way to bring this part of the display information to the
screen or any other way of getting this to work?