adding extra marker styles
how do we add extra marker styles into an excel chart? we have used all the
ones it has given us in 2003, but there use3d to be many more in 2002, how do
we get them back?
Here is an explanation on how to add custom markers.
I don't think the marker style have changed since xl2000.
> how do we add extra marker styles into an excel chart? we have used all the
> ones it has given us in 2003, but there use3d to be many more in 2002, how do
> we get them back?
Andy Pope, Micro...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...Macros not performing correctly
I recorded a macro to place a vlookup formula in four cells that are side by
side. When I run the macro it only performs the first task, it does not go on
to do the other three. I used the tab key to go to the next cell while
recording the macro, I don't know if that's why it's not working or if it's
The script looks like this:
' EERates Macro
' Macro recorded 3/4/2005 by BCBSOK
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-2],Sheet1!R3C1:R102C2,2,0)"
ActiveCell.FormulaR1C...Coloring a row
I have a spreadsheet and I want to have cells colored from column A to K if
cell h is not blank. So if h3 has a date in it I want A3:K3 to be say light
blue. This is for Office 2003. I can do it with conditional formating in
2007, but my work place doesn't have 2007. I did use column L and put an if
statement to give a true or false in the cell depending on if the cell in
col. h was empty or not. Any ideas how to get this to work?
This sort of thing will work in 2003 conditional formating. In Cell
A3 go to Format - conditional formattting. Formula is
Paste...Adding support for mfc / atl types in a Win32 project
MSDN says this about adding support for classes shared between atl &
mfc (I'm just after points and rects btw)... just add the header (
I'm getting linker errors for these classes though. Is there a lib I
need to add? Any screwy build options need changing? It's in VC 2003.
In the project wizard I note that atl and mfc support aren't available
when creating an empty Win32 application.
On 26 May 2006 07:42:09 -0700, Simon L wrote:
> MSDN says this about adding support for classes shared between atl &
> mfc (I'm just after points and rect...Problem with macro assigned to custom toolbar button
Problem with macro assigned to custom toolbar button
I am having a probelm with macros assigned to a custom button on
custom button. I am using excel 2000.
1. I have created a macro called "Jump" in a workbook named "Test1"
2. I then created a custom toolbar and added a custom toolbar button t
3. Through the customize dialog box I assign the Macro "Jump" to th
Everything works fine UNTIL.
If I do a SAVE AS for the workbook "Test1" and call it something els
like "Test2" and then close "Test2" an...Excel Grid Lines in Outlook Preview Pane
Is there any way to send a spreadsheet to a mail recipient in the body
of the message and not have the grid lines show up in the Outlook
preview pane when the recipient views the e-mail? If you open the
e-mail in Outlook, the grid lines disappear, but in the preview pane
they are there.
Using Excel and Outlook 2003.
Uzytkownik "Kimberly" <Blackrose73@gmail.com> napisal w wiadomosci
> Is there any way to send a spreadsheet to a mail recipient in the body
> of the message and not have the grid lines show up ...Can you delete Business Alerts?
I cannot see any way to delete Business Alerts, can someone tell me how?
I am using GP 8.0
Try going to Cards --> System --> Business Alerts.
Charles Allen, MVP
"Sheri Salomone" wrote:
> I cannot see any way to delete Business Alerts, can someone tell me how?
> I am using GP 8.0
> Sheri Salomone
woo hoo! Thank you!
"Charles Allen" wrote:
> Try going to Cards --> System --> Business Alerts.
> Charles Allen, MVP
> "Sheri Salo...Duplicate Rows
I have an extract from a student information system in Excel that
looks like this.
Student Class Grade Quarter
John Chemistry 70 1
John Chemistry 80 2
John Math 95 1
John Math 100 2
Alice Chemistry 67 1
Alice Chemistry 47 2
Alice Math 88 1
Alice Math 85 2
What I would like is this:
John 70 80 95 100
Alice 67 47 88 85
However, since there are hundreds of students, this would be an
extreme pain to do by hand. Is there any built-in formula or function
in Excel that can do this?
What is it that you actually want to do? (The best approach depends on what your desired end r...How do you delete an Assembly Item?
I have an assembly item code, and I want to delete it to make it inactive. I
cannot find any help on this, nor can I actually FIND the assembly item.
This is a multi-part message in MIME format.
You can't make an Assembly inactive as its not really an item, just a =
reference to a group of items. You can delete it though.
One way of finding items is by their Item type. Click on the Item Type =
column header and th...Add rows automatically? Accordion
Is there a way to automatically add/show rows that have data?
I have a data entry sheet. Then I have a report.
The report pulls data from the entry sheet.
If there is no data for a specific line/row item, is there a way to
automatically hide or not show the row(s) with no data?
can I have more than one autofilter on a sheet?
> Use the filter function
> Select the data and click on...
> This should make an arrow appear at the top of the data (in the header row).
> click the arror and select "Nonblanks"....C# Adding Days to a Date
I have 2 objects:
objContract.activeon and objContract.expireson.
I am trying to add 364 days to objContract.activeon and assign it to the value
// Contract Start Date
DateTime dt = DateTime.Now;
objContract.activeon = new CrmDateTime();
int iFound = 0;
string sTemp = "";
if (objAccount.paymenttermscode.Value == 1) // due on receipt - use Todays
objContract.activeon = objInvoice.CFDinvoicedate;
else // ...VB Macro #2
I have a macro that is generating Excel files. When the macro runs, it saves
two different tabs in the workbooks as values. It needs to test and wait
until the formulas that are pulling amounts from another database are
correctly populated with the amounts.
Right now, I am getting N/A# instead of amounts for some, but not all, of
the files. I think the problem is that the formulas have not completed
pulling the amounts before the macro pastes that tab as zeros. (N/A# is what
appears when the formulas have not completed calculating - once they have
completed, the N/A# is replaced ...Ugly lines between emails in viewing pane
Operating System: Mac OS X 10.4 (Tiger)
Email Client: pop
I have Outlook at work and you can turn these lines off but I cant find anywhere to turn these off in Entourage 2008. They weren't there in Entourage 2004. Is there anyway of turning these off to get a clean view? I've looked in preferences and customising only seems to extend to choice of columns. Andrea
> I have Outlook at work and you can turn these lines off but I cant
> find anywhere to turn these off in Entourage 2008. They weren't the...Delete dead mailbox from active directory
We have four exchange servers - two E2K and two E2k3. One of the E2k server
just died due to corrupt array control. We had no mailboxes or anything
else on that server. One of our administrator must have created one mailbox
on that server by mistake and he never realized that until now. server died
and we deleted that mailbox from active directory but, when i try to remove
the server from system manager i get message saying can't remove because
there are mailboxes associated with this information store. Is there any
other way i can remove that server from active directory or s...Formatting a subtotal line with a macro
I already have in use a macro that runs a sort and subtutal function. I
would like to format the subtotal row using visual basic since there is
already a macro in place.
Look at this:
ActiveCell.Font.Bold = True
"DJDKAL" <email@example.com> skrev i meddelelsen
>I already have in use a macro that runs a sort and subtutal function. I
> would like to format the subtotal row using visual basic since there is
> already a macro in place.
This is what I've g...best fit line
I have a line graph with 6 series plotted (I.e. 6 different lines--sales on y,
months of x). How do i add a best fit line to the chart? When i select Add
Treanline, it only lets you select one series (and I'm assuming the result
you get is a linear y=mx+b line....i 'm looking for the best fit line for
Message posted via http://www.officekb.com
since it is a line chart, there are several things you could try.
If it is justified, you could generate an average of the data points for
each x point and plot it. Make a trend line of the average th...how can you add more rows in excel 2000?
Is there a way to add more rows to excel's already 65536 rows? In other
words can you expand excel to have more rows then it already has.
HTH. Best wishes Harald
"Khody" <Khody@discussions.microsoft.com> skrev i melding
> Is there a way to add more rows to excel's already 65536 rows? In other
> words can you expand excel to have more rows then it already has.
Unfortunately, you can't increase the number of rows. Versions 2002 and 2003
have the same limitation.
"Kh...Mass Delete Contents of Inbox
How can I delete contents of inbox all at once. It would take me all week
if I had to do it manually.
It is mainly notifications on undeliverables to the system administrator.
Edit | Select All, then press Delete.
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
"Adin" <firstname.lastname@example.org> wrote in message
> How can I delete contents of inbox all at once. It would take me all week
&g...UNABLE TO FWD ITEMS TO DELETED ITEMS
Can't delete an item from the inbox or anywhere else
except the DELETED box. Receive the error: The messaging
interface has returned an unknown error. If the problem
persists restart Outlook. Last date known that could
successfully delete items 12/12/03. Don't know what
happened at the time as I was called in after the event.
Have restarted Outlook - no luck.
Checked Knowledge base - recommended installing SP1. As it
already exists on ws,won't let me overide existing SP1.
Possible causes as per Knowledge base not the causes in
Does anyone have any suggestion...unable to Delete shape
I am using Visio 2000 (6.01245), if i select a shape and press delete button
on keyboard then shape dosent delete.Can anyone tell what is this problem.How
can i resolve this problem.
Does object have gray boxes in corners when selected? If so, object has
"Asif" <Asif@discussions.microsoft.com> wrote in message
>I am using Visio 2000 (6.01245), if i select a shape and press delete
> on keyboard then shape dosent dele...Fulfillment type orders
We have orders at the initial status (just entered) and the options to allow
delete documents and void documents are enabled on the Sales Order Type.
However, we can't get a void or delete button unless we move the fulfillment
order through the confirm process to an "Invoice" to get a Delete?
What's up with this? Very annoying.
I know it is subtle and wish there was a better way to display it, but the
Void option only applies to Invoice type IDs and not Fulfillment Order type
IDs ("Void Invoice Documents" vs. "Delete Documents"). Since both t...referencing lines and series points
what is the VBA code for referencing to individual points in a line on
line graph? i would like to create a macro to change indiviual points
shapes and the color or the lines in between them to different color
depending on different parameters. is this possible
medicenpringles's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1645
View this thread: http://www.excelforum.com/showthread.php?threadid=39101
Ther easiest way to do this is to first record a macro doing what y...Can't re-enter a previously deleted User ID
We changed the spelling of a User ID (applewicks to appelwicks) and then
deleted it (since he couldn't remember his password and the button for
password was greyed out so we couldn't change it.) And now we can't re-enter
the same user ID even though it doesn't appear in the window any longer.
Here is the error we get: ODBC SQL server driver: The log in appelwicks
already exists. Thanks!
I believe you have to delete the old ID through Enterprise Manager as well.
> We changed the spelling of a User ID (applewicks to appelwicks) and then
...mysession & deleting a line item on the pos screen
I want to automatically have my dll delete a line on the pos screen. So I
have tried to do a myssion.transaction.entries(1).Delete and other sorts of
things. Does anyone know of a way to accomplish this?
Thanks in advance for any help on this.
Use code like this:
For Each item In mysession.Transaction.entries
If FindItem(item.item.id, item.quantity, item.item.description) Then
> I want to automatically have my dll delete a line on the pos screen. ...