Excel: Want chart to be steps, not slopes

[cpc34]

I have a cumulative chart, which shows the total attendances at a certain type of event over time. I want it to show attendance going up step-wise when each event happens (ie. holding at 6 people, and then jumping straight to 9 people). Instead, it makes a straight-line slope between each consecutive point. I have turned smoothing off, but it still does it. Any ideas?

 

[AnotherHiggins]

Use a Column Chart instead of a Line Chart.

[tt]_____
[blue]-John[/blue][/tt]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Hi,

The key is to have TWO y-values for a category value.

The FIRST y-value for the given x-value is the same as the previous y-value.

The SECOND y-value for the given x-value is the "step value".

For instance...
[tt]
x y
1 0
2 0
2 1
3 1
3 0
[/tt]
is a step from 0 to 1 to 0.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}