Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a line overlaid on some bars in a pivot chart in excel, but I want the line to be stepped instead of curved. How can I accomplish this?

share|improve this question
    
When you right click and "change series chart type" what have you selected? Could you provide an example of what you have vs what you want? –  Raystafarian Feb 2 '12 at 17:37
    
So as chart type I selected line. This gets me pretty close to what I want. I have sloped lines between data points, but what I would like is to have a verticle lines between the data points and then have short horizontal likes at the data points. –  loveforvdubs Feb 2 '12 at 19:12

2 Answers 2

up vote 2 down vote accepted

For anything to do with charting in Excel, @Jon Peltier is the man but a line chart that looks as on the left below can be converted into a stepped chart as on the right without calculation quite simply by repeating the X-axis values (in order) and inserting duplicate values with an offset as shown:

SU385252 example

Though I admit I don't really know whether this is what you would like.

share|improve this answer
1  
wow thanks for finding a year old problem and answering, that's awesome! I can't even remember what the problem was though, so I can't tell ya if your answer works or not. But it looks pretty great to me! Thanks again! –  loveforvdubs Apr 3 '13 at 18:05
    
I have a tendency to be late - but my excuse here is that I wasn't a member a year ago :-) –  pnuts Apr 3 '13 at 18:20
1  
haha seems like a solid excuse to me –  loveforvdubs Apr 3 '13 at 21:45

Error bars can be quite useful, even if you do not know what they are fully for; in most cases, they can be used to show variations in data; but when used creatively, they can turn any line into a stepped line.

Here's a writeup of it: Step Charts in Microsoft Excel

Essentially, your adding error bars to a range of data, and then just hiding all but the error bars; turns out quite nicely, if you follow the instructions.

There is another method; however, that involves adding extra data to your chart; or, adding extra calculations to the chart, to 'simulate' data.

share|improve this answer
    
I tried the error bar method and did not have much success. Could you elaborate on the extra calculations method? –  loveforvdubs Feb 3 '12 at 13:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.