View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Formula help Formula help is offline
external usenet poster
 
Posts: 6
Default Problem with line Chart

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