Prev: Where can I get a free gauge chart for excel?
Next: Graph Text Relationships with Relative Time X?
From: Formula help on 10 Dec 2009 10:49
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


From: Herbert Seidenberg on 10 Dec 2009 14:06
Excel 2007
Various approaches with
PivotTable, PivotChart, Step Chart
http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_10_09a.xlsx
From: Jon Peltier on 10 Dec 2009 22:35
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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Formula help wrote:
> 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
>
>
 | 
Pages: 1
Prev: Where can I get a free gauge chart for excel?
Next: Graph Text Relationships with Relative Time X?