Excel 2000 Line Chart Problem...HELP !!!!

  • Thread starter Thread starter jozz65
  • Start date Start date
J

jozz65

I want to plot a line chart of interest rate changes.

The rates change a maximum of once a month on a pre-set day an
sometimes may not change for several months.

If I plot the line chart in excel the line it draws simply join
together the points so I get diagonal lines between two periods as i
the rate had changed progessively from one rate fixing to the next.

This is not the case.

The rate steps vertically from one fixing to the next.

ie 1st May rate is fixed at 4% then 1st June rate fixes to 4.25%

I only want to show months on my x-axis not all 365 days of the year.

Excel will show a smooth progression from 4% 1st May to 4.25% 1st Jun
giving the appearence that on 15th May the rate was 4.125%

What should be shown is that on 1st, 2nd, 3rd, ....... 15th, 16t
...... 31st May the rate was 4% and that on 1st June it went verticall
up to 4.25 %.

How can I achieve this.

I have looked at numerous tutorials and cannot find the answer.

All help gratefully received.

Many Thnx

Jozz ;-
 
If you can switch to a XY Scatter chart, you can use the technique on
the Excel/Charts/Step chart page of my web site.

Otherwise, if you want to stick with a line chart *and* the x-values
are 'time', modify your data so that

1-Jan 10
1-Feb 12
1-Mar 15

becomes

1-Jan 10
1-Feb 10
1-Feb 12
1-Mar 12
1-Mar 15


--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
jozz65

Double click on the lines, choose patterns and in the line section choose none. This will only show the data points

Hope this helps.
 
Tushar

Many Thanks

The X - Y Scatter is problematical as I am actually using two axi
(Which I failed to mention ;-) ).

Your other solution works fine and seems so simple when you think abou
it..... Doh !

Thanks again for the speedy response.

Luck

Jozz ;-
 
You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004
 
Back
Top