Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have the following data:
Date Value 1/07 700 3/07 550 9/07 600 10/07 550 7/08 500 9/08 700 2/09 750 8/09 600 I would like to create a simple line chart connecting the Value points. Note that the points correspond to random dates (not evenly spaced). How can I create a line chart that has time on the x-axis, (say shown in months) with a line connecting the Value points, which are shown at various locations in time. Sounds simple but I am having difficulty creating it. If using months on the x-axis, I get the connecting line dropping down to zero for the months with no data. I want the line connecting only the listed Value points (i.e. 700, 550, 600, etc.) Thank you, Bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem adding vertical marker line to line chart | Charts and Charting in Excel | |||
LIne chart problem | Charts and Charting in Excel | |||
chart line style problem | Charts and Charting in Excel | |||
Line chart in VBA - non trivial problem | Charts and Charting in Excel | |||
problem with drawing vertical line on chart | Charts and Charting in Excel |