Dates in x axis

[Jenny55]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

Hi

I know this has been posted by others before but I can't seem to find an answer. I want to have a dual chart (bar with line) both sets of data belong to the same date data set. While I can easily make the x-axis do what I want when I use a scatter plot, I want to be able to manipulate the scale on the x-axis with the bar graph.

When I go to the formatting menu and try to change anything on the x-axis scale I keep getting the error - "The entry is invalid for the data used by this chart. Please enter a value that falls within the minimum and maximum data values used by this chart"

I use this type of graph all the time for work and I never had a problem in older versions of Excel. Can anyone help?

Thanks
Jenny

 

[Eric Waldbaum [MSFT]]

Hi Jenny,
Thank you for posting this issue and sorry for any inconvience. This
appears to be a known issue that we have been investigating, please see
workaround information at:
http://www.officeformac.com/ProductForums/Excel/3461

-Eric
MacOffice Testing
Microsoft

--