Missing Features in Excel 2008!?

B

BobP

Hi JE,

thanks for the answers on 1 & 2 plus the Adobe add-in. I've further explored the twin axis issue and have found that by double clicking on a series in a chart that it brings up the "Format Data Series" window where you can click on "Axis" and choose to plot the series on a secondary axis. This then shows up on the Formatting Palette under "Chart Options" where you can deselect and reselect it.

Bob
 
R

Ronnie

Thanks a lot. It works. Is there a way I could do a search in XL and get more then one results? Let's say I'm looking for all the employees of a company. Maybe I should use some kind of filtering?
 
V

Vassilis

How i can add a secondary vertical or horizontal axis in a chart. I can not find an answer.
 
J

JE McGimpsey

Thanks a lot. It works. Is there a way I could do a search in XL and get more
then one results? Let's say I'm looking for all the employees of a company.
Maybe I should use some kind of filtering?

If your data is in columns, you can use Data/Filter/Autofilter. Choose
the company name from the company filter dropdown
 
J

Jim Gordon MVP

Hi,

Please take a moment to express your disappointment to Microsoft.

For Excel:
http://www.microsoft.com/mac/suggestions.mspx?product=excel

For Word
http://www.microsoft.com/mac/suggestions.mspx?product=word

Thanks.

-Jim


in said:
"I found that there is no way to customize the error bars."

Me Too.

WHAT A DISAPPOINTMENT. Oh, and another huge disappointment is the inability to
use EndNote with Word 08. If you do research, you may want to consider waiting
to upgrade until they fix some of these seemingly regressive changes.


--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
J

Jim Gordon MVP

Hi

John is referring to a new feature in Office 2008. You no longer have to use
the Print dialog box. Now in the File > Save As dialog box you can choose
PDF as a file type.

-Jim


Maybe I'm missing something here, but OS X will let you convert any
document in any application to PDFs. As part of the process you can
even automatically email or fax the resulting PDFs.

Just open your 100 page workbook and select Print from the File menu.
The PDF option is at the bottom on the left of the Print menu. Just be
sure to select the Workbook option if you want to convert all pages.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
J

Jim Gordon MVP

Hi,

As John pointed out, Mac versions of Excel don¹t support pivot charts. The
makers of the Mac version of office do not get much feedback indicating this
is a feature that would be used much on the Mac.

You can change that situation by sending feedback to Microsoft and letting
them know that you need pivot charts in Mac Excel and why you need them.
Here¹s the link:
http://www.microsoft.com/mac/suggestions.mspx?product=excel

I¹ve seen postings about the lack of pivot charts several times over the
years, but it¹s important for those who want this functionality to make a
point of letting Microsoft know.

Thanks.

-Jim


We use pc Office 2003 to build excel pivot charts and then copy them into
powerpoint presentations. We can then "drill down" into the underlying pivot
table if needed, during the powerpoint. Wondering if MacOffice 2008 has this
capability?


--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
J

Jim Gordon MVP

Do I, no.

Does Microsoft? I don¹t speak for Microsoft, but my conclusion is, ³yes.²

If you don¹t think AppleScript is an acceptable substitute for VBA then
please let Microsoft know (please be civil). Explain to Microsoft that even
though you are a Mac user that you use VBA and how the lack of VBA affects
your ability to use Office. I think in Microsoft¹s view most Mac users are
³consumers² not ³developers² and that we can get by without VBA for the most
part.

Here¹s the URL:
http://www.microsoft.com/mac/suggestions.mspx?product=excel

Thanks.

-Jim


I cannot believe that Excel 2008 no longer supports VB macros. Like them or
not they were essential to automating serious spreadsheets. I and I suspect
many other serious users will never upgrade until support for VB macros is
reinstated. Do you really expect me to rewrite all my spreadsheets using
Apple's scripting??


--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
W

warteschleifenpianist

It's very easy to create a chart with two vertical axes - and it looks cool. Just make a chart with two or more series of data. The select the series (one by the time), double click to format it and choose "Axis". There you can select to use the primary (lefthandside) or secondary (righthandside) axis for that particular series. The second axis then appears of course automatically and can be formatted as appropriate.

Hope that helps...

And hopefully anybody here to help me assigning data as labels for the horizontal axis!
 
B

BobP

I've investigated this and agree that it's a pain, however I have a work around for you (for dates).
1. Enter the data column with years as a Date format. This will require entering in dates ending in the year you want.
2. Format the data column as a custom format of "yyyy" to display only the year.
3. Select the two columns you want and plot the chart. Excel appears to recognise dates and uses it for the horizontal axis labels/ intervals.

Hope this helps.

Bob
 
W

warteschleifenpianist

Thanks a lot Bob. I just tried it and it worked. However it is a lot of work to change the years to dates, reajust the dates. In Numbers 08, it works similiar, however you have to convert the label data to "text" and then it is automatically taken as labels.
 
C

cassv

I've been trying to get into Data Analysis and Charts and Lists etc., and they won't open. A message comes up saying: 'charts' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

Can somebody please tell me how to combat this problem?
 
1

1cassv

I've been trying to get into Data Analysis and Charts and Lists etc., and they won't open. A message comes up saying: 'charts' cannot be accessed. The file may be read-only, or you may be trying to access a read-only location. Or, the server the document is stored on may not be responding.

Can somebody please tell me how to combat this problem?
 
J

JE McGimpsey

I've been trying to get into Data Analysis and Charts and Lists etc., and
they won't open. A message comes up saying: 'charts' cannot be accessed. The
file may be read-only, or you may be trying to access a read-only location.
Or, the server the document is stored on may not be responding. <br><br>Can
somebody please tell me how to combat this problem?

What version and update of XL and Mac OS X?

Data Analysis requires you to load the Analysis Toolpak Add-in for XL
versions prior to XL08. The ATP won't run under XL08, since it doesn't
run VBA. There are workarounds using XL functions here:

http://www.coventry.ac.uk/ec/~nhunt/oatbran/

I'm not familiar with "Charts and Lists"...
 
J

JE McGimpsey

Hi JE, <br><br>thanks for the answers on 1 &amp; 2 plus the Adobe add-in.
I've further explored the twin axis issue and have found that by double
clicking on a series in a chart that it brings up the "Format Data Series"
window where you can click on "Axis" and choose to plot the series on a
secondary axis. This then shows up on the Formatting Palette under "Chart
Options" where you can deselect and reselect it. <br><br>Bob

Thanks for the response - the "bug" I was referring to was regarding the
Secondary Axis button on the Formatting Palette - which it seems to me
should be able to do the same thing. I'll have to think through that
some more...
 
J

JJZ

Looking forward eagerly to spreadsheets with more speed and more real estate, I guess I just didn't imagine Microsoft would compromise something as long-standing and functional as macros.

So, I was stunned to hear that macros cannot be created in Excel 2008 for the Mac. Not that Visual Basic was ever as understandable as the old macros in Excel, but at least it was something.

Then I learned that there is no Solver function and no Data Analysis pak in Excel 2008. Surely this can’t be true. Why bother with the new version if you are the denied features you have now? No Solver. No Data Analysis. No macros. It makes no sense.

I am profoundly disappointed. What is the market share is required to provide fully featured software for Mac users? 10%? 15%? Never?
 
J

Jim Gordon MVP

Hi JJ

Market penetration of the Apple computers on the whole is one thing, but the
perception is that Mac users are ³consumers² and ³creative types² who really
don¹t use or have much use for VBA or any products created using VBA.

VBA is often considered something for ³developers² and ³business² people,
not us Mac users.

So if you want VBA support you¹ll have to explain to Microsoft why a
³consumer² or ³creative² person would ever want to use it. In the past, VBA
usage on the Mac has been minimal. You limit your use of spreadsheets to
tables of information for your holiday card list, right? Maybe do your
homework assignment? Surely you have no interested beyond that, do you? You
would never make or use an add-in, right?

-Jim

Looking forward eagerly to spreadsheets with more speed and more real estate,
I guess I just didn't imagine Microsoft would compromise something as
long-standing and functional as macros.

So, I was stunned to hear that macros cannot be created in Excel 2008 for the
Mac. Not that Visual Basic was ever as understandable as the old macros in
Excel, but at least it was something.

Then I learned that there is no Solver function and no Data Analysis pak in
Excel 2008. Surely this can¹t be true. Why bother with the new version if you
are the denied features you have now? No Solver. No Data Analysis. No macros.
It makes no sense.

I am profoundly disappointed. What is the market share is required to provide
fully featured software for Mac users? 10%? 15%? Never?


--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info
 
J

JE McGimpsey

What is the market share is required to provide fully featured software for
Mac users? 10%? 15%? Never?

Overall market share doesn't mean very much. There are a number of
markets for Office on Macs, all with different user profiles: Home,
small business, academic, research, enterprise, etc.

Not all Macs are even being bought to run Mac OS. A significant fraction
of Macs sold will never have Office installed on them.

Features will be evaluated based upon what each of those segments say
they need, upon how those needs fit relative to the needs of other
segments, upon the relative size of the segments, upon the technical
ease or difficulty of implementing solutions for those needs, and upon
the resources available to implement those solutions.

In the case of VBA (which took out Solver and the ATP as collateral
damage), the biggest factor was probably NOT market need. Rather, the
limiting factor was the resources available to rewrite and update the
VBA compiler, editor and run-time environment.

Even if a significant number of Mac developers had suddenly been
available (and that's not a given - MacBU typically has had fairly
substantial difficulty finding qualified coders), the magnitude of the
job made it unlikely to be completed in a reasonable time for this
release.

Remember that, while planning for Office 2008 started in 2004 (with
long-term planning beginning even earlier), Apple made the job much
bigger in June 2005, when they announced the Intel-based Macs. Not only
did that add a significant amount of unanticipated work to ensure that
Office 2004 ran in Rosetta, but also that *everything* in Office 2008
had to be moved from its CodeWarrior base to XCode in order to run
natively on the Intel chipset. That's millions of lines of code for each
of the major apps and Office core.

Obviously for those that need VBA/Solver/ATP, Office 2008 may not be
worth getting (though if one likes Office08's Word, PPT & Entourage
apps, one can certainly run XL04 along with them). But those folks -
which include me: I'm out of a job for most of my major clients - aren't
*any* worse off than they'd have been if the release of Office 2008 had
been delayed until 201x - they'd still either be using Office 2004, or
they'd find a different solution.

That would mean *no* sales, even to those that don't need VBA (a
substantial part of the market never uses XL at all), for that
additional time. For a division that is required to make a profit,
that's a bad option.

All that said, I think that, even with the market research that they do,
MacBU underestimated the users of Solver and the ATP. To reinforce that
perception, and probably help Marketing and Product Development allocate
resources, it's imperative that everyone who's unhappy that VBA was not
included submits Feedback via Help/Send Feedback...

MacOffice may weather this version without VBA - and certainly MS as a
whole would like to kill VBA, though it's fighting back mightily. But my
guess is that if it doesn't have cross-platform automation capability by
*next* version, it will permanently become a hobby suite.

Let them know that we don't want that to happen!
 
B

BobP

I would like to echo the need for a fully functioning Excel 2008 program for Mac's (Defined as Excel 2004 functions plus new ones) . There are many business users of Office who are forced to use PC's at work and have Mac's at home. Inter-compatibility of functions and performance between the two platforms is critical for these users. To label Mac users as "creative" types and PC users as non "creative" types is foolhardy at best. I agree with JE Gimpsey that the probable cause for the lack of VBA etc is due to a business decision to release Office 2008 sooner rather than later. Other omissions or bugs such as twin axes charting (which is more cumbersome than before) and being able to easily select data as labels should be fixes Microsoft must implement.

I've kept Office 2004 installed in addition to installing 2008 (or not installing Office 2008) and would recommend that others do the same until Microsoft issue appropriate updates that result in a program that is comparable on functions and ease of use to Excel 2004.
 

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

Top