Excel 2004 chart problems displaying data and setting options

[cirya]

Hi!

I upgraded to Excel 2004 and find it functions very differently than
previous versions. I'm having an odd problem making charts with some
data only on Excel 2004, not with Excel 2001 on older Mac, or Excel 97
on very old PC.

1. Data set is 7 rows and 8 columns. Excel refuses to plot anything but
the last two columns. Tweaking every setting in chart wizard doesn't
matter. (Excel 2001 & 97 plot the data fine - but using 8 & 9 year old
computers isn't practical.) The data are straight numbers.

2. Similar small data set as above. First 4 columns are $ (in the 10ks)
and last 2 columns are %. The "display with 2 axis" chart option
refuses to use anything but $ on both Y axis. Also, I can't figure out
why there's no option to specify the alternate Y axis and why Excel
gives the option to specify an alternate X axis.

I've always been an Excel geek (e.g. I use pivot tables, solver, many
functions) but this new version of Excel behaves very oddly compared to
old familiar versions, and the "documentation" is less than
enlightening.

I'd appreciate any advice.

 

[CyberTaz]

Hello-
Just a thought since you are evidently dealing with files created in an
earlier version:

The data are straight numbers.

Are you sure? Check the formatting and make sure they are not _text_

2. Similar small data set as above. First 4 columns are $ (in the 10ks)
and last 2 columns are %. The "display with 2 axis" chart option
refuses to use anything but $ on both Y axis. Also, I can't figure out
why there's no option to specify the alternate Y axis and why Excel
gives the option to specify an alternate X axis.

Same thing here... At one time % was not an allowable character for a value.

Regards |:>)