Problem with line Chart

  • Thread starter Thread starter Formula help
  • Start date Start date
F

Formula help

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
 
1. You need to enter the day, month, and year of the date, not just
month and year.

2. Remove the blank line between headers and numbers.

3. Delete the word Date so the top left cell is blank.

4. Select the range including both columns and the top row with the
blank cell.

5. Create your line chart. The valid date format and the blank cell help
Excel parse the data and plot what you expect.

- Jon
 
Back
Top