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
|
|||
|
|||
Line Chart for Dates
Done Date
client 1 1/1/08 client 2 3/1/08 client 3 7/23/08 etc... ect.... My spreadsheet looks like the above. I'd like to to create a line chart that will show the bottom chart line all the dates in the year starting with 1/1/08 thru 12/31/08 and my line to to represent the above dates plotting the dates within the bottom chart line so we can see where our busy time of the year is. I'm trying the chart wizard on the above spreadsheet format but it's not giving me the format I want? Suggestions??? Thanks in advance! |
#2
|
|||
|
|||
Line Chart for Dates
Date is your X value. You need some data for Y as well.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Brw" wrote in message ... Done Date client 1 1/1/08 client 2 3/1/08 client 3 7/23/08 etc... ect.... My spreadsheet looks like the above. I'd like to to create a line chart that will show the bottom chart line all the dates in the year starting with 1/1/08 thru 12/31/08 and my line to to represent the above dates plotting the dates within the bottom chart line so we can see where our busy time of the year is. I'm trying the chart wizard on the above spreadsheet format but it's not giving me the format I want? Suggestions??? Thanks in advance! |
Thread Tools | |
Display Modes | |
|
|