Widening charts and adding vertical lines
Hi,
I'm using Excel 2007 and am having two big problems:
1) I'm trying to look at a pretty wide range of data (monthly interest
rate changes over the course of an 8-year period) and it's important
that I be able to see the chart from a wide angle so that I can see
trends around specific dates, but I can't widen the line chart so that
it spreads out the data- if I try to do so, it eliminates data on one
end or the other instead of widening the entire chart.
2) I want to add in vertical lines at certain custom intervals to show
events taking place. I can't figure out whether it's possible
gridlines or drop-down lines at anything but automatic intervals, but
if it is possible does anyone know how to do this?
Thanks for any help.
|