Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Widening charts and adding vertical lines
1. Select the chart, then click and drag the right border further right.
2. Add custom lines or gridlines to a chart: http://peltiertech.com/Excel/Charts/AddLine.html http://peltiertech.com/Excel/Charts/...Gridlines.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vertical lines | Charts and Charting in Excel | |||
I just want lines to appear on my worksheet vertical and horizont | Excel Worksheet Functions | |||
Vertical lines in a line chart | Charts and Charting in Excel | |||
Automatically adding Vertical lines after certain points in line graph | Charts and Charting in Excel | |||
Vertical Lines on the Lines on 2 Axes Chart | Charts and Charting in Excel |