Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart problem when I open file in 2007
Hi!
I have a problem with a line chart I made in Excel 2003 it is a line chart that shows selling numbers during a year. On the x-axis I show the last day of every month. The base unit is days and the main unit is month. my min value is 2006-01-31 and maxvalu is 2006-12-31. It works fine in 2003. The problem is when I open the file in excel 2007 then the x-axis shows the dates 2006-01-31 2006-03-03 2006-04-03 2006-05-03 and so on showint the third of every month except for januari. It shows it right if I instead show the first of every month, the problem is that I have made this graphs for several years and they allways shows the last day of every month so it hard to change this policy now. How can I do to make my chart look right in excel 2007? Many thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
line chart problem when I open file in 2007
Looks like a bug. The axis works nicely in Excel 2000-2003 (and probably in
earlier versions), but is mangled in Excel 2007. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Lina" wrote in message ... Hi! I have a problem with a line chart I made in Excel 2003 it is a line chart that shows selling numbers during a year. On the x-axis I show the last day of every month. The base unit is days and the main unit is month. my min value is 2006-01-31 and maxvalu is 2006-12-31. It works fine in 2003. The problem is when I open the file in excel 2007 then the x-axis shows the dates 2006-01-31 2006-03-03 2006-04-03 2006-05-03 and so on showint the third of every month except for januari. It shows it right if I instead show the first of every month, the problem is that I have made this graphs for several years and they allways shows the last day of every month so it hard to change this policy now. How can I do to make my chart look right in excel 2007? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can not open .xlsx file in Office 2007 Beta 2 | Excel Discussion (Misc queries) | |||
excel 2007 does not open file on first try | Excel Discussion (Misc queries) | |||
Can't open a 2003 file in 2007 | New Users to Excel | |||
Can't open Excel 2007 file with 2003 | Excel Discussion (Misc queries) | |||
Can't open file in 2007 | Excel Discussion (Misc queries) |