Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 07 - Line Chart with Month-end dates
Having difficulties creating a line chart using daily balances, but I would
like the x-axis to show the month-end date. My start date is 12/31/2007 and my end date is 6/30/2008. I have daily information that I would like plotted, however only the month-end date (1/31/2008, 2/28/2008, etc) to show. I have experimented with the axis options (day, month, year), however it seems to default to the 1st day of the month. If using every 30 days, it also becomes off. Please help. I'm using an existing chart from Excel 03, and it will not convert properly...I've also tried creating a new chart from scratch. Thanks, Lori |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Combime individual dates in a month in a Pivot Chart | Charts and Charting in Excel | |||
Column-Line Chart w/ Dates | Charts and Charting in Excel | |||
Line Chart with dates in 5 day working week only | Charts and Charting in Excel | |||
How do I sort a list of dates in Excel by month and day? | Excel Discussion (Misc queries) |