Suppressing categories with 0 values
I'm trying to build a dynamic chart for sales data. The output file contains two columns, A and B. Column A contains categories, i.e. Apples, Oranges, Pears, etc.,. and B contains sales data, i.e. 5, 0, 10, etc.,. respectively. The ouput data comes out monthly. Some months will contain sales from all categories, some ten, some fifty. I want the chart to only graph categories with non-zero values, i.e. if there are 100 categories and only 30 with sales numbers there is no point in showing the other 70 categories with zero values. I can format column B with zero values to show ...Worksheet Changes
Have a worksheet that has data in the range A5:I105, would like cell
a2 to show a date that any of this data has changed, was thinking of
using a worksheet change_Event to manage this but not sure of how to
go about setting this up, have used the simple change event for a
single selection i.e A1 or B4 but not with a range area.
Any help would be Great
A bit more explanation along with layout and what desired output looks like.
Microsoft MVP Excel
"Steve" <firstname.lastname@example.org> wrote in mes...Default mail account in Outlook 2000
I use Outlook 2000 to send and receive email from several different
POP accounts. Sometimes I want to send emails from one account, while
other times I want to send them from a different account. I know that
Outlook allows you to change which account a message is sent from via
the "File | Send Using" menu option. My problem is that I often
forget to use that option and just click the "Send" button on the
toolbar. This sends out the message using the Default POP account.
After it has been sent I remember that I didn't use the "Send Using"
My quest...Find a value in list 2 that is not in list 1
I have text values in column A and also in column B, most of which match. I
would like to take the values in column B that are not in column A and put
those values only in column C. Any help would be greatly appreciated.
Put this formula in column C, and copy down.
To get them contiguous, use Autofilter, filter on nonblanks in column C, and
copy/paste to somewhere.
mvpearl omitthisword at verizon period net
"maxxwell2" <email@example.com...RE: MSCRMDeletionService -- change frequency...
i am trying to modify the frequency for the MSCRMDeletionService...there is
a registry value in the HKLM\Software\Microsoft\MSCRM\ key named
DSRunInterval. one of our servers has this value as a REG_SZ (string) value
while another server has it as a DWORD (number) value ; does anyone have an
idea what format this value should be? and also is it based on seconds?
...Customise doesn't keep changes.
I have Money 2005... I would like to customise some report in order to avoid
some categories in reports. I did it for "Spending by Categories" report.. I
ommited some and it worked great, howevver, when I return to home the report
still show the categories I ommited and when I go to the report waht I
customised is gone.
Is there a bug in this?
Can I create new report from nothing at all? or from a template?
In microsoft.public.money, Marcell wrote:
>I have Money 2005... I would like to customise some report in order to avoid
>some categories in reports....changing the delimiter while saving as txt file
is there a way to change the delimiter to # instead of tab
characters while saving the excel file to .txt file.
Thanks in advance
"raj" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Dear Experts,
> is there a way to change the delimiter to # instead of tab
> characters while saving the excel file to .txt file.
> Thanks in advance
And some more links...
Maybe you can steal some cod...OWA Change password option
I've read through your various postings and articles, relating to OWA change
password option under a front-end / back-end 2003 SP2 senario. Please can
you clarify the following steps I need to follow:
1) Create a new Iisadmpwd virtual directory in IIS on the frontend server.
2) Run the OWAADMIN tool, and select enable password feature on both the
front-end and back-end servers.
Can you clarify if by using the OWAADMIN tool, that I won't have to manually
edit the registry on both servers as the tool will take care of this for me?
Can you also clarify, which services (if a...Can't change default print resulotion in Publisher 2003
In Publisher 2003, I tried to change the print quality via the "Printer
Properties" dialog box, but that didn't change the print resolution. I
clicked "Advanced Print Settings..." in the print dialog box, but the only
drop-down choice next to "Resolution" is "Default," which doesn't say what
the default is but seems to be set at Super-fine.
How do I cange the print resolution to Normal or Draft?
Don Burgess <DonBurgess@discussions.microsoft.com> was very recently
heard to utter:
> In Publisher 2003, I tried to change...Changing Functional Currency #3
There is a live company ABC. We created the new company XYZ then I restore
the live company database ABC to the newly created company XYZ by following
the KB article 871973. Then we delete the all the transaction in XYZ company
because we need the same company setup and masters with that we added
required additional master data.
The problem we are facing is we need to change the functional currency in
XYZ company. How can we do this? Any one can help us
I don't believe you can change the functional in XYZ since there were
transactions. Howabout creating a 123 com...Copying text value based on long (comlex) calculation
I am not sure how to even search for what I want to do, so please
forgive me if my first post has been discussed and resolved ad naseum
in the past...
Here is my situation:
- I have a workbook that contains multiple sheets.
- Each sheet contains auto parts from different suppliers, sorted by
- Some suppliers have parts that overlap with each other and the
various sheets are updated as pricing and availabilty of parts change.
- I am using a combination of the VLOOKUP and MIN functions to
determine which supplier has lowest cost based on a comparison of part
numbers and price ac...I want a formula to ignore text values in cell references
If text is input into some cells referenced by a formula I want the formula
to ignore whatever text it finds and just calculate the result of the numbers
in cells. How do i do this?
Presently the formula displays #VALUE! where there is text in one or more of
the cells referenced.
In place of A1 use =IF(ISNUMBER(A1),A1,"")
> If text is input into some cells referenced by a formula I want the formula
> to ignore whatever text it finds and just calculate the result of the numbers
> in cells...Changed relationship; records no longer linked
I have a Corporates table holding details of company customers.
I have a CorpContacts table holding details of our contact persons at those
Originally I had a relationship (one to many) between Corporates.CorpName
I had a Corporates form which contained a CorpContacts subform displaying
the contact persons' details. All working fine.
But if we updated the name of the company i.e. Corporates.CorpName, the link
was lost and the contact persons were no longer displayed.
So I introduced new fields in each table ("CorpID"), i.e. some...Changing OLAP Pivot Table Connection Source
I have numerous spreadsheets that have pivot tables pointing to an
OLAP Cube via a connection string. Is there an easy way (either
automated or manual) to change the connection string to point to a new
version of the OLAP Cube? I can edit the connection properties and
navigate to the new .odc connection file, but get an error saying "The
OLAP provider returned an unexpected number of dimensions."
...Removing Campaign Templates and Template Activities from default v
I am trying to figure out how to prevent template activities and campaign
templates from showing up in default views in the "Activities" section of CRM
as well as the "Advanced Find" and "Regarding" views.
...in Excel: How do I change "selected cells" highlight color?
When I select cells in Excel the shading is so light (blue) that I can barely
tell which cells are selected from those that are not. Can I change the
background color of cells that are selected?
Assuming Excel 2007 this is a known problem and as yet no patch for it.
I don't have Excel 2007 but I have read that playing with your Contrast can help
Gord Dibben MS Excel MVP
On Tue, 10 Jun 2008 12:51:00 -0700, flameretired
>When I select cells in Excel the shading is so light (blue) that I can barely
>tell whic...What's the default for circular logging in Ex2003 on/off?
Thank you -Moises
Disabled ie unchecked for lots-o-logs
Circular logging was a soultion when storage was expensive. You can get
larger drives cheaper now so it shouldn't be enabled if at all possible.
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup.
Use of included script samples are subject to the terms specified at
"MG" <email@example.com> wrote in message
news:1...Data validation for 2 valid values
I want a cell to allow only 2 valid values but not have a drop-down list
How do I do that with Data->Validation?
Data>validation>allow>list, put the 2 values separated by a comma in the
source box, uncheck in cell dropdown
"Hall" <firstname.lastname@example.org> wrote in message
> I want a cell to allow only 2 valid values but not have a drop-down list
> How do I do that with Data->Validation?
Using a list, as Peo suggested, will force users to match the ...how do I get the x-axis to plot values rather than categories in .
how do I get the x-axis to plot values rather than categories in Excel
By using an XY rather than a LINE chart
Bernard V Liengme
remove caps from email
"Boggins" <Boggins@discussions.microsoft.com> wrote in message
> how do I get the x-axis to plot values rather than categories in Excel
...Change Percentage DIV/0! Error
I'm trying to see the change between (A) 2002 unit sales and (B)200
unit sales, and am using the following formula:
This gives me the difference negative or positive, however if A (200
sales) is zero, then I get the DIV/0! error, how do I fix this?
Message posted from http://www.ExcelForum.com
A couple of things you might want to consider. One is
that your formula will not take into account what the
change is if the prior month base amount is negative. To
fix that use the =IF(base=0,"",(current-base)/ABS(base))
This should help
>-----Or...Invoice Item Posting Account defaults to Cash account instead of Income, Sales account
Great Plains 7.00g12
Our VAR doesn't know the answer to this:
Our Invoice Item Posting Account defaults to the 'Cash' account instead of
the expected 'Income, Sales' account. We can override this manually for
each item in the invoice.
After entering an item on the invoice. (I've attached a screen shot)
Looking at the distribution in the Sales Distribution Entry window:
The Credit shows as type SALES but the Distribution Reference shows as Cash.
We cannot figure out why this is happens.
Selecting the Sales Item Detail Inquiry Zoom then selecting <Distributio...A question regarding coordinates of points within a chart
Can anyone explain how x-y coordinates for points within a chart can be
accessed via a mousemove event? I realize this will require quite a bit of
coding, but I would like a little comment box to appear for any given point
on an X-Y scatter I have. The data set consists of around 27000 points, and
I would like the mousemove event to trigger a lookup into a table that
contains a fairly lengthy descripion of each point.
Take a look at Jon Peltier's article on chart events . . .
then, take a look at this post ...how can I change the a,b,c, column headers in excel to names
I've tried and can't figure out how to change the column header from a,b,c,
etc. to names for each column. Any tips are appreciated
You can only show A,B,C...,IV or numbers: 1,2,3,...,256
But you could put your names in Row 1 and then select A1, then select A2 and
click on Window|Freeze panes.
> I've tried and can't figure out how to change the column header from a,b,c,
> etc. to names for each column. Any tips are appreciated
...Vendor Changed Names and Need to reassociate items with new Vendor
We have a situation were a couple of Vendors have changed names through
acquisitions and we need to create a new Vendor ID for these vendors. What
we would like to do is copy the items we have associated with the old vendor
to the new vendor so we do not have to recreate all the items again.
Is there a way to create a new vendor ID and copy the items linked with an
existing vendor ID to the new vendor?
Great Plains has a tool called Professional Services Tool, contact them. The
tool is not free. It will do exactly what you are looking for.
> We ..."Reply" cursor default location
Something changed just yesterday that is driving me
crazy. I accept that I must have done something to cuase
this (hitting some sequence of keys perhaps), but I have
no idea how to fix it.
When any of us receive an email from a sender and elect to
respond to it by clicking on the "reply" button, what
happens to me now is that my cursor defaults to the
address "To:" box in the new reply message rather than the
message content area where I would typically just be able
to start printing my reply message. Needless to say, I
start typing away, galnce up at the scree...