Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
want 1 value to display for each stairstep of chartered values
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
want 1 value to display for each stairstep of chartered values
Hi
I'm not sure what a step chart is exactly so this is a stab in the dark. Create a bar chart, then double click one of the bars this will bring up the Format Data Series box, select the Options tab, and set Gap Width to 0. This should give a step chart effect. HTH Naz "MBush" wrote: 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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
want 1 value to display for each stairstep of chartered values
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Repeat values only in a column. | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
How to display cell values in wordarts? | Excel Discussion (Misc queries) | |||
Format cells to display truncated values? | Excel Discussion (Misc queries) |