ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Line Chart for Dates (https://www.excelbanter.com/charts-charting-excel/211007-line-chart-dates.html)

brw

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!

Jon Peltier

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!





All times are GMT +1. The time now is 03:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com