Horizontal axis scale issue

G

gkclr

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

After creating a chart in excel and using the date MON-YY format for the Horizontal axis (or any other date format for that matter), if I then attempt to format the axis and select the Scale menu item every time i attempt to select or deselect i receive an 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."

This even occurs when I attempt to uncheck the Vertical (value) axis crosses between dates.

How do I get around this issues?
 
E

Eric Waldbaum [MSFT]

Thank you for reporting this information. The workaround is in the Format
(Horizontal) Axis dialog's Scale pane to only have numeric date values (like
9/1/2007 as a min, 12/1/2008 as a max, and 9/1/2007 as Value (Y) axis
crosses at textbox value). Sorry about any inconvenience, we are
investigating this issue.

Thanks again,
Eric
MacOffice Testing
Microsoft
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart horizontal axis can't be edited 2
Converting to Log scale with primary and secondary y axes 2
Dates in x axis 1
Date X-Axis in Excel Chart 2
SPOD for a couple minutes when trying to change Number format 2
Change the axis type on a XY (Scatter) plot 1
Vertical axis crosses at.... 3
Secondary horizontal axes 1

Top