Creating a "step" effect with line graphs

  • Thread starter Thread starter kavius
  • Start date Start date
K

kavius

I have a graph that charts a velocity over time. As the velocity
decreases I want to display the maximum integer velocity possible
(without going over) at that time.

The problem is that I would like to have the integer values displayed
without diagonal lines (can't have fractional parts of a whole
number).

I know there is a way to do it (a friend did this once, but can't
remember how). Can anyone think of how to do this?

Code:
--------------------

+-----------+-------+-----+
| Date | Vel | Int |
+-----------+-------+-----+
| 13-Jan-04 | 24.58 | 24 |
| 14-Jan-04 | 24.17 | 24 |
| 15-Jan-04 | 23.75 | 23 |
| 16-Jan-04 | 23.33 | 23 |
| 17-Jan-04 | 22.92 | 22 |
| 18-Jan-04 | 22.50 | 22 |
| 19-Jan-04 | 22.08 | 22 |
+-----------+-------+-----+

--------------------

I've attached what I do have so far (in case you don't get what I am
trying to do).

Attachment filename: kaviusqs.zip
Download attachment: http://www.excelforum.com/attachment.php?postid=411391
 
If you are willing to switch to a XY Scatter chart -- no reason I can
see why you shouldn't be -- check the Excel | Chart | 'Step Chart' page
of my web site.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top