Re: Step chart

Attachments are strongly discouraged in newsgroups, and generally hinder
rather than helping you to get an answer for a number of reasons, including:
- Many readers will not see your question at all because posts with
attachments are filtered out.
- Of those who do see your question, most knowledgeable participants
will not risk opening your attachment
- A good description is usually easier to follow than figuring out
what your example is about.
- Writing a good description often helps you see the answer without
asking the question.

Without opening your attachment, my best guess as to what you are asking
is how to get x-axis tick marks only at specified values on a step chart.

In order to put tick marks only at specified values on an X-Y type
chart, you must either use a "Line" chart, which does not treat the
x-axis as an arithmetic scale, or the specified values must be equally
spaced so that you can set the properties of the x-axis (Minimum and
Major unit) to force the desired values to be tick marks.

You can create a step chart either with error bars per
http://www.tushar-mehta.com/excel/charts/step_chart/
or by plotting each line segment individually. Both approaches require
that the x-axis be treated as an arithmetic scale, so you can only
accomlish what I think you are asking if the desired values are equally
spaced.

Jerry

Pieter-Jan wrote:

> Hello,
>
> Last week I got a very good advise to make a step chart out of a line chart.
> The answer was on: http://www.tushar-mehta.com/
> So far so good but now I have problems with the X-axis. The value of the
> X-axis scale is a time scale but I have points on specific times and want
> only these times on the X-axis. In my case Excel shows the complete time
> scale between minimum and maximum values. Hopefully the attachments makes
> clear what I mean.
>
> Your help is much appreciated.
> Thank you in advance.
>
> Kind regards,
> Pieter-Jan Verheijen
>
>
>
>