Is there a way to show 2 series as 2 stacked columns on 1 chart?
For example -
x-axis = quarters of the year: Q1, Q2, Q3, Q4
left y-axis = projected sales by region as a stacked column
right y-axis = actual sales by region as a stacked column
Regions = America, Europe, EMEA, APAC
This chart can help get a quarterly comparison of projections vs actuals by
quarter and region.
Jon Peltier has a nice step by step procedure for this here
> Is there a way to show 2 ...2007 -> Money+/update Part II, would you like another account?
When I did the initial upgrade to Money+ or the patch right before I had to
disable my Citibank account then re enable it. This process went fine and was
working for like the last month. I think there was another update last week
or so and ever since then when I update it adds duplicate accounts for my
Citibank Checking and Savings account then complains at me to merge. If I
tell it to merge then it wants to discard all my entries in these accounts
for the last year… (Needless to say I don’t want to do this)
So now even if I do merge the accounts the next time I go to update it adds
...excel values from + to -
how to cahnge a selected series of values from positive to negative in one
- enter -1 in an empty cell
- copy this cell
- select your numbers
- goto 'Edit - Paste Special' and select 'Multiply'
"jjshariff" <firstname.lastname@example.org> schrieb im
> how to cahnge a selected series of values from positive to negative
In a empty cell and copy this cell
Select y...MAKE ALL IT CERTIFICATIONS
MAKE ALL IT CERTIFICATIONS - A PIECE OF CAKE
Now all IT Certifications like MCSE, MCTS, MBS, SCJB, A+, CCIE,
CCNA, CCNP, Oracle 10g 9i, IBM, HP, Vmware and many more are made a
Piece of Cake. Visit Now http://www.FreeExamKing.com and become an IT
Certified in first attempt.
...How do I create a click on + symbol to open a root and click on -.
I'm looking to create an excel file with drop down menus.
I'd like to have a category. Click on the "+" symbol and the category opens
up and shows all of the subcategories.
Each category can further be opened if I so choose.
Each category can be have a number total associated with it.
When you click the "-" symbol. The subcategories close and the sum total of
all subcategories is shown in the category total.
example. creating a budget.
Category is utilities
sub categories are: phone, cable, electric, gas, etc...
Monthly utility total ...Excel is working slowly when I have several tabs with 20,000+ rows---- any way to speed it up?
Hello - I am having a consistent problem when I build a series of
spreadsheets that contain many rows (usually about 20-50,000 rows in
several spreadsheets), and contain several "if formulas", and contain
several Vlookup formulas.
I get a "calculating cells" message for basically every little thing I
do--making my work very, very slow. Just to simply add a column, it
will take as long as a minute.
I have excel 2003.
Any recommendations on how I can avoid this problem, or make things go
You could switch off auto recalc (Tools>Options...>Calcu...CSV Import Error on text field with +- (Excel 2003)
I'm trying to import the following file (test.txt) in Excel 2003:
[Start of File]
Header 1,Header 2
A test+-20,A test|30+-20
[End of File]
When I attempt to import this, I specify both columns as Text in the
Wizard. However, I get the following in Excel:
A1: Header 1
A2: Header 2
B1: A test+20
B2: A test|30+20
It's dumping the minus sign on me.
(a) know why this is happening,
(b) know how to get around it, and
(c) know any related problems that I may encounter when importing?
(b) is most relevant to me at present. The others are nice-to-know
S...Excel macro list
In Excel 2003 I used to be able to list all macros in a workbook by pressing
Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
Is there still a way of accessing macros via Alt+F8?
Any suggestions appreciated.
ALT+F8 works for me in E2007. What do you mean by 'I get is a series of
ribbon help letters'
> In Excel 2003 I used to be able to list all macros in a workbook by pressing
> Alt+F8. Now all I get is a series of ribbon help letters... What's changed?
> Is there still a way of...(Cut
I am coding a project in vc++.
I am not able to cut and paste the row in the excel file
from one cell to another.
Will you PI suugest the code in vc++ for this implementation.
My code :
range = objSheet.GetRange(COleVariant("A8"), COleVariant("K6"));
VARIANT result = range.Cut(....Demands for Destination value ?......)
...Can Excel email someone when a cell goes + or
So sort of like Conditional formatting where it changes colour - instead it
adds rules to send an automatic email... Is this reaching for the stars?
Start here Reload Internet
Regards Ron de Bruin
"Reload Internet" <Reload Internet@discussions.microsoft.com> wrote in message
> So sort of like Conditional formatting where it changes colour - instead it
> adds rules to send an automatic email... Is this reaching for the stars?
I bet VBA...Excel 2007+AnalysisServices2005SP2: Pivot Table to SSAS why menu item "Options"->"Formulas" is disabled?
I am using Excel 2007 with SQL Server Analysis Services 2005 SP2. IN Excel
2007 I want to
create calculated measure based on other measures, but I cannot do this for
Pivot table. If I go to menu "Options"->"Formulas" I can see that it is
disabled. Same menu is enabled if I create Pivot table based on cells in
How can I create caclulated measure for Pivot Table based on SSAS?
...Campaign Response + Marketing Lists -- Very Very URGENT
I want to add Marketing Lists in to Campaign Response form.. There
is a lookup for selecting customer. In that lookup form the dropdown list
contains Lead, Account, Contact. Is it possible to add Marketing List in to
that? I want to show the Marketing lists in Campaing Response form... Can
anybody please suggest me how to do?
Thanks in Advance
A campaign response is for a single contact / company etc and not multiples
which would be what you would have if it allowed you to select a markting
list os the answer is no not at this time.
==========================...MDI + Resizable Panel
in MDI, want panels like "search" / "favorites" / "media" in IE with features:
1. only one is visible.
2. can be hide.
4. remember old inputs and size when hide and reshow.
...How can I hide/unhide columns with those neat + and
I wonder how can I insert those neat little + and - signs that allows
users of the sheet to quickly hide and unhide set of rows/columns?
Would be nice feature to learn, but I don't even know what it is
called, so it makes it hard to search from help or google =)
Select the rows to group, Data>Group And Outline>Group
(replace somewhere in email address with gmail if mailing direct)
"Sirritys" <email@example.com> wrote in message
> I wo...open .chm file from VC++ - with Table Of Contents hidden
how could i launch/open a .chm file from my app(VC++ - VS2005), where in the
..chm has to open by default without any TOC(table of contents) in the .chm.
In detail,I am using
::HtmlHelp(GetSafeHwnd(), sFileName, HH_DISPLAY_TOPIC,0);
where sFileName is the path including the .chm file name.
Now, when i execute the above piece of code I am getting .chm launched but
with EXPANDED TOC, which i dont require for my functionality.
Can any one suggest, How by default the TOC can be hidden and the .chm can
be launched ??
I mean currently HIDE, BACKWARD,FORWARD, PRINT ...Exchange
in the normal way, Outlook doesn't show the body of an e-mail.
Can be changed in the registry by adding the key:
"SaveAllMIMENotJustHeaders". Works fine. But if a mail is beeing
sent/received over an Exchange Server, the body is cut off.
Can this be changed?
[http://xaitax.de - firstname.lastname@example.org]
...Formatting of phone numbers- want to delete +1
I bought a new Microsoft 7 based computer and restored my .pst files to
Office 2007 on it. Now all of my phone numbers are formatted with a +1 in
front of the 10 digit number. I have researched this issue for 3 days and
have not found a solution that works to delete this +1 which I believe is the
Does anyone have a fix for this?
The option not to add the country code to new phone numbers has always been
Actions > Call Contact > New Call... > Dialing options
There are very few if any reasons to do so, however.
"carolina...Office 2011 Excel Beta 3+ cell right-click context menu won't work
I've been running the beta versions of Mac Office 2011. Up until Beta
3, I could right-click in an Excel cell and get the context menu as
expected. Now, starting with Beta 3 and into Beta 4, I have lost that
functionality. Has anyone experienced this? I can't find a
preference/setting that would bring this feature back. This is very
frustrating and I can't figure out what may have changed to cause this.
On 7/14/10 10:17 AM, in article
Barry" <email@example.com> wrote:
> I've be...Excel example-formula C4+C5 adds before data in C5 Can I get it t.
I'm trying to create a formula (for example):
In cell D5 I want it to add C4+C5. I would like it to work only after there
is data in C5, but not before. How can I get it to work only when there is
data in C4 & C5? Right now its showing what I have in C4.
=if(count(c4:c5)<2,"Not enough values!",c4+c5)
New Excel User wrote:
> I'm trying to create a formula (for example):
> In cell D5 I want it to add C4+C5. I would like it to work only after there
> is data in C5, but not before. How can I get it to work only when there is
> data in C4 & C5? R...Excel is calculating strange since a long time ... (0.05+(-0.07)+0.02+0) =?
Type in a column
and sum up all.
What's the result ? -3.46945E-18
Common, where did they go to school ?
In article <firstname.lastname@example.org>,
> Type in a column
> and sum up all.
> What's the result ? -3.46945E-18
> Common, where did they go to school ?
Excel and almost every other computer program maintain decimal (base 10)
numbers in binary (base 2) floating point. Bina...Historical Aged Trial Balance not showing 91-180 and 181 + after 9
We have upgraded to 9.0 and now our Historical Aged Trial Balance report is
not now showing the last two columns of 91-180 days and 181 + days. It only
shows the 91 + column. I am not sure how to change these calculated fields
in Report Writer. If someone could helpe me, I would appreciate it!!!
Those calculated fields should already be there. Look for Period Amount4,
Period Amount5, etc. in the calculated fields list for document details. You
should also see Apply Bucket 4, Apply Bucket 5, etc. for payments and Total
Bucket 4, etc. for the totals.
Jim@TurboChe...Excel 07 + iSeries Excel Add-In crashing
I am test bedding Vista and Office '07 with our legacy programs.
As our main databases reside on an AS/400, we extract considerable data for
reporting by way of the iSeries Access for Windows Excel Add-in. This has
always worked fine in previous versions of Office.
However, in Excel '07, when attempting to run the connection, the program
The add-in works properly up until the point when the data is to be
virtually transferred to the Excel sheet. (You can see the libraries and
files, make field selections, and play with the data options etc.).
Running the transfe...GetForegroundWindow for layered+click-through+HWND_TOPMOST window
How can I determine if a layered (=click-through) + HWND_TOPMOST window
is the current top level window?
It's not possible to determine this by using GetForegroundWindow()
because layered windows are being ignored.
I can't believe that it's completely unknownin which order the windows
have to be painted, so I guess that Windows does have this window
somewhere in a collection, right? I was hoping that by going through
this collection, I could find out what's the real foreground window.
...How do you turn off/on the "1" or "2" or "+" or "-" view hide/unh.
What is or how do you control, turn on/off the small "1" "2" or "+" "-"
hide/unhide view buttons right above the "A" cell? Sometimes shows when I
'Data - Goup/Outline'
> What is or how do you control, turn on/off the small "1" "2" or "+"
> "-" hide/unhide view buttons right above the "A" cell? Sometimes
> shows when I hide columns.
You can toggle them to hide or display with
Hi, help me, please,
I have workbook in Excel 2000 with 12 sheets with the same names of
fields (changes only dates) and I need to every sheet was merged with
diference file in the Word application. Thak you for your time and your