View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day Kelly O'Day is offline
external usenet poster
 
Posts: 103
Default want 1 value to display for each stairstep of chartered values

MBush:

Here's a link to a how-to on step charts in Excel. The downloadable workbook
shows you how to construct the step chart and how to enhance the X axis (for
dates) using a dummy axis series.

http://processtrends.com/pg_charts_d...xis_series.htm

Kelly

www.processtrends.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?