Line graphs; excel 2007
I have a simple line graph - and I'd like to shade in the area btwn the two
lines only (not the whole background of the graph). Any suggestions?
Apply Fill Color Between Lines in a Chart
Peltier Technical Services, Inc.
> I have a simple line graph - and I'd like to shade in the area btwn the two
> lines only (not the whole background of the graph). Any suggestions?
...RE: linking Contact to Opportunities...
we are trying to solve an issue where we need to track a Contact's "role" to
an opportunity...a contact can be associated to more than one opportunity so
defining the role at the Contact level wont make sense and it seems that we
can't customize the ContactOpportunity object (which links contacts to
opportunities) ; does anyone know whether this will be customizable in v2-0?
if not is there any way to customize the ContactOpportunity object? thanks!
I know for a fact the CRM 2005 will offer more support across the board for
customizing entities and relations...Excel 97 #11
How can I change a spreadsheet , so that it opens on sheet 1 every tim
someone goes into it , when working on the spreadsheet, it will ope
the last page that a save was done on.
Message posted from http://www.ExcelForum.com
Your 1st question. Save at the sheet desired or use an auto_open macro in a
regular module or a workbook_open event in the ThisWorkbook module that uses
"EADesktop >" <<EADesktop.firstname.lastname@example.org> wrote in message
news:EADesktop.163m6...Is is me? Or is Excel 2007 Charting Lame?
Maybe I'm missing something. If so, let me know.
The process of creating a chart is unintuitive and cumbersome. A big
step backwards from 2003. The manual says to just select your data
and insert the chart. What I find is that 95% of the time, I have to
re-do the data selection. If I highlight two columns and insert the
graph, Excel thinks both columns are two different series instead of x
and y axis.
I create two columns, label one of them "X", one of them "Y". Put
some numbers below that. Now insert an XY chart. One would think
that it could figure out "...Adding a column in Excel 2007
Have a column with letters in it. Want to sum up how many of one
letter I have in the column. What is a formula to do this please
To count the number of cells that equal X
To count the number of cells that have at least one X in them:
> Have a column with letters in it. Want to sum up how many of one
> letter I have in the column. What is a formula to do this please
On Dec 10, 10:44=A0am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> To count the number of cells that eq...excel process in the background
I'm trying to find a way of updating the excel
spreadsheet without the excel application coming up on
the users PC. We are getting input from the WEB and
using that input to run a model and capture the data in
an excel spreadsheet. Then manipulate the spreadsheet and
create a summary Word document that will be emailed to
the user. Then the user will be emailed with the summary
data from the excel document. The thing is that this will
be running on some server and I don't want the excel
spreadsheet or application to actually come up on the PC.
How can I suppress the applicati...Shared use of excel work books
Can anyone tell me "if I have an excel workbook (with multiple worksheets
that report to the first worksheet) on a shared drive whether it can be set
up for multiple users to access it and use it at the same time?" These users
will be accessing their single worksheet to update it periodically with the
first worksheet being the project leaders sheet where he gets to see all the
other worksheets on his one sheet.
You can do this by selcting "shareworkbook" from the tools menu and checking
the 'allow changes by more than one use'.
Beware th...EXCEL 2003
Im performing Logical boolean operations using MS Excel. The only problem is
that its displaying result set as "TRUE/FALSE" and I want to have the result
Is there a way to convert that text "TRUE" into digit "1"?
please tell me ASAP.
"imfaizzi" <email@example.com> wrote:
> Is there a way to convert that text "TRUE" into digit "1"?
returns 1 for TRUE and 0 for FALSE. Similarly for =1*(A1>A2)
"imfaizzi" <firstname.lastname@example.org> wrote ...Microsoft Excel ASC II Text Files
How do I convert an Excel spreadsheet into this type of
file in order to import to another program such
as "MaiList & AddressBook"
try saving as 'CSV' file in the Save As dialog. This is a comma
separated text (ASCII) file
Bill Cadwallader wrote:
> How do I convert an Excel spreadsheet into this type of
> file in order to import to another program such
> as "MaiList & AddressBook"
I have files in quantrum pro and would like to open them in excel. But they
I'm not familiar with Quantrum Pro. What does it do?
"Liz R" wrote:
> I have files in quantrum pro and would like to open them in excel. But they
> won't popen
...Excel worksheet merge
I have searched google, but to no avail. Here goes. I have one set of
excel worksheets (one is an exact link to the other) that I copied four
times for a total of five. I moved the 1st worksheet of each to an
individual folder. So what I am left with are the 5 link worksheets. Can I
merge the links together? I have an Access db that I will use to process
the info. I have linked the links to an Access db and it works. Except I
have 5 dbs instead of the one that I really need. The fields are the same
in all linked dbs. My question is- should or can I merge before access and
i...Excel Services Publish
I have a 64 bit client (Windows Server 2008) and my colleague has Windows 7
64 bit client. We are trying to publish an Excel 2007 document to MOSS,
which is running under https, and is sitting on a 64 bit operating system.
We keep getting the "File Not Saved" error when we try to publish from our
clients. However, a 3rd colleague has Windows XP 32 bit and can publish the
same exact Excel files just fine up to the very same MOSS location we tried
on the 64 bit clients.
Can someone from MSFT confirm that this is an issue with 64 bit clients?
Can you present a solut...Excel pivot tbl
Brand new laptop w/Windows XP. Has Office 97 installed
(first), than complete install of Office XP(second). Than
install of PTSfull.exe (pivot table services that come w/
sql server analysis services service pack 2).
Go to data manu - PivotTable and Pivot Chart report -
External data source/Pivot table - Get Data - OLAP cubes -
new data source - select an olap provider for the
database you want to access - blank dropdown (no
Microsoft OLEDB Provider for OLAP Services or Microsoft
OLEDB Provider for OLAP Services 8.0).
Tried removing Office 97 & Office XP than installing PTS -
sa...Date formatting in Excel #2
How do I format a cell to return Oct 04 when I type 10-4 in Excel...When I
type 10-4, Excel returns Oct 05.
When no year is typed, excel would assume it is the
current year. You would ahve to type the full date
(including 2004) for it to display as Oct 2004. Use
Format - cells - date and then select the particular
format you want from the options there.
>How do I format a cell to return Oct 04 when I type 10-4
in Excel...When I
>type 10-4, Excel returns Oct 05.
...Re-download Office Outlook Live
I have a current and valid subscription to Microsoft® Office Outlook® Live
and the Office Outlook Connection so I can use my Windows Live Mail account
I need to reinstall this software to a new laptop but I cannot find where to
get this from. And believe me, I have looked. When I originaly subscribed I
opted to download the software rather than have it posted to me at home, but
even now I cannot see that option available either.
Has anyone any suggestions please?
did you log into your member account? http://membercenter.msn.com/
Diane Poremsky [MVP - ...retaining fonts when placing excel worksheet into pagemaker?
I am currently placing excel worksheets into Pagemaker software. I am having
particular trouble with retaining the fonts in the text cells. When it
appears in pagemaker the spacing is wierd and the numbers eg.(12/8) are
crammed together. I used excel 2003. I am not a pagemaker wizard soooooooooo
I think PageMaker will let you Edit-->Paste special-->as a picture, won't
it? Sorry, it's been a long time...
"parrydise" <email@example.com> wrote i...Templates Excel XP
Where can I find templates to download to Excel XP. I'm looking for
templates for both business and personal use
(No private emails please)
"sfrich1" <firstname.lastname@example.org> wrote in message
> Where can I find templates to download to Excel XP. I'm looking for
> templates for both business and personal use
If you forget the address in the future, go to Excel's menu, and select
Help | Microsoft Office Onl...Excel macros page breaks but not on row 1 and column value in footer
Hi, I have seen some posts that are similar, but no one seems to have
the problem that I am having. I will post my macro in this, for anyone
that is interested.
My users get a csv file every month, and we have to clean it up. This
macro does that.
My last issues are this:
1) having the spreadsheet create page breaks whenever the value in
column B changes. Below is just that code.
col = 2
LastRw = ActiveSheet.UsedRange.Rows.Count
For X = 2 To LastRw
If Cells(X, col) <> Cells(X - 1, col) And Cells(X, col) <> Range("B1")
ActiveWindow.SelectedSheets.HPageBreaks...When Excel Opens it Starts with Book2
Anyone know why excel would open to book2 and not book1.
This means that a file with the Book1 name has already been saved.
Find it using Start > Search > For Files and Folders
Check the contents and either rename or delete.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
...Does Pocket Excel run VBAs?
I have desktop spreadsheets with VBAs - would they work
in a Pocket PC/Pocket Excel environment?
Hi F Chuck!
Sorry but Pocket Excel does not support VBA.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"F Chuck" <email@example.com> wrote in message
> I have desktop spreadsheets with VBAs - would they work
> in a Pocket PC/Pocket Excel environment?
...Using Excel error #N/A in a formula
I would like to capture the error message #N/A in an IF statement
Would like to use IF(MATCH(C1,Range,0)=#N/A,"OK","STOP") but it does not seem to work. What is the correct syntax to capture the #N/A error message and display "OK" instead of #N/A?
>I would like to capture the error message #N/A in an IF
>Would like to use IF(MATCH(C1,Range,0)=#N/A,"OK","STOP")
but it does not seem to work. What is the..."freeze panes" in excel '97?
A colleague of mine has the Excel version '97 on his computer and would like
to know if you can also freeze panes in his version (he has a Dutch version)
My English excel 97 certainly has a Freeze Panes option under the Windows
(replace somewhere in email address with gmail if mailing direct)
"Jolanda van Tuijl" <Jolanda van Tuijl@discussions.microsoft.com> wrote in
> A colleague of mine has the Excel version '97 on his computer and would
> to know i...Excel: When printing some cells will not print text in them
Operating System: Mac OS X 10.5 (Leopard)
When I print an Excel 08 spread sheet, two of the cells that have text in them will not print the text in the cell. All the other cells with text prints fine. The text does not even show up on print preview in the print dialogue box.
Any suggestions on how to get it to include the text in these two cells?
...Excel Re-Calc causes network traffic and very slow response times.
Excel Ver 2003 SP2
Windows XP SP2
Microsoft SBS Server 2003
Workstations: P4 2Ghz, 512 Mb Ram
I have an excel file with hundreds of vlookup and indirect formulas. It
has no links to any other spreadsheets. The file resides on a shared
network drive on our server. When users do a recalc or change a number
in the file causing a recalc it takes about 7 seconds... however after
a bit of experimentation I find that if we open the file and then
disconnect the workstations network cable the recalc takes less than
one second !
Tried saving the file to the local drive of a workstati...How to open multiple cases
Does anyone know if there's a way to open a case for several companies at one
time? I've got a situation where I need to deploy a service bullitin for
serveral companies. The title, description, etc.. are all the same.
Hmmm. Do you really need to open cases at first? If it's just a bulletin,
then maybe you create a campaign to notify the appropriate customers, and
then track the responses against the campaign.
Microsoft Certified Professional - Dynamics CRM
> Does anyone know if there's a way to open a ca...