If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Problem with line Chart
Excel 2007
Various approaches with PivotTable, PivotChart, Step Chart http://c0444202.cdn.cloudfiles.racks...12_10_09a.xlsx |
#3
|
|||
|
|||
Problem with line Chart
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 |
Thread Tools | |
Display Modes | |
|
|