Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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
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
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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .