Step curves

[Jan Rennel]

Hi,

I need a VBA-program for drawing step curves, i.e. the curve is horizontel until the y-value changes. The curves are thus discontinuous. A good example could be price curves.

An example is enclosed where x represents quaters and then there are data series, in this case Y1, Y2 and Y3. In this example there should thus be three curves.

Could some one help me?

Kind regards,

Jan

[PCI]

See next code
Of course make a copy of the sheet

Please Login or Register  to view this content.

[mrice]

Please see the attachment, The closest that I could get was to use a histogram with overlapping bars and not fill.

[Jan Rennel]

Hi!

Thank you very much for your macro.

I suppose it is designed for 3 sets of Y columns.

If you would like to change it to any number of columns , i.e. 2,4,5 etc. and not only 3, how would the macro be changed?

Kind regards,

Jan

[PCI]

Here we are

Please Login or Register  to view this content.

[Jan Rennel]

Hi!

Thanks for all help with the macro!

It functions now properly!

Kind regards,

Jan

[PCI]

My pleasure
PCI