newbie needs help
First to let you all know, I am a big novice at this kind of stuff, so
please bear with me.
What I am trying to do is make a trendchart with 9 different plots on it.
How do I change the numbers on the side and bottom of the chart to read what
I need them to? I take these tests 3 times a week and would like to chart all
of them seperately and also together to chart progress for a whole month.
One for each day, and then one for the month. Then I would like to do the
same for the following months of the year. And I would like to have one chart
to show the progress for the whole...clustered stack column charts #2
I am trying to create a chart with three stacks in two columns. I tried
using the method described by Bernard Liengmen's but it doesn't allow me to
add a secondary axis for the last (sixth) data series. I don't get it???
How does one series in a stacked cluster use the secondary axis?
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
Lou T wrote:
> I am trying to create a chart with three stacks in two columns. I tried
> using the method described by Bernard Liengmen's but it ...Help! Unable to mount public folder store event 9519
I am getting the following error when tring to mount the public folder store.
Event Type: Error
Event Source: MSExchangeIS
Event Category: General
Event ID: 9519
Error 0x8004010f starting database "First Storage
Group\f7967383-856a-4b7f-9023-37c269a0e908" on the Microsoft Exchange
Look up of DB Info failed.
For more information, click http://www.microsoft.com/contentredirect.asp.
I have tried numerous ms kb articles to no avail.
I did find this on a news group :-
I'm looking for help some help with a formula.
How would I go about a formula for automatically adding 8 hours to a
number each calendar month? I would like to open it and have it done for
me if that's possible rather than having to remember to add it each
month or forgetting if I did or not.
For instance, i start out with the # 248 in a cell that I would like to
automatically add 8 to each calendar month.
"Gadgetman" <firstname.lastname@example.org> wrote in message
> I'm looking for help some help with a formula....Creating a view with concatenated columns
I have a table with about 20 columns and I am trying to create a view of it
about 10 columns. The problem is that in the process, I am trying to
fields into one field and I am unable to get any thing working. Below is one
my attempts to tackle this. Any ideas will be highly appreciated.
// The following should be considered as pseudo-SQL
CREATE function [dbo].[fn_myview] (@CardNo varchar(11)) returns Table
declare @FullName as nvarchar(128)
(SELECT FirstName, FatherName, GFatherName, FamilyName, Birthdate,
Birthplace...Conditional Formatting for a certain month
Having a bit of an issue at the moment, ive got the Cell for instance
Basically Im after some conditional formatting to say if the month is
January, then make the cell blue.
Which will then lead to me making the other cells different colours
depending on their month, but again, it has to be in this format
Thanks for any help, muchly apreciated
Assuming a properly formatted date, formula is
"Advo" <email@example.com> wrote in message
news:1158151582....Rich Text control formatted as bold??
I have a control field on my form that is setup as textformat = rich text. In
the memo field on the form I need specific parts of the text to show up as
Upon form load I am populating the field with string data such as:
Me.MyTextBox = "This is a test string generation."
I need to set bold only one or two words of this string. The way I understood
it was that if I was using Rich Text format it would convert the formatting
to HTML style. But I don't see and havent found examples HTML formatting like
[b] [/b] working in VBA.
What is the correct way I can do t...I need help with a formula
I'm making a stock list sheet and I like to put on it the value - and +
like when I take boxes out it will give me the total and when I add in
it will change also.
This is for a weekly count.
I'm very new to excel so please H-E-L-P-.
I need the instruction like u give it to a child. :) :)
Thanks a lot
pampam's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=26224
View this thread: http://www.excelforum.com/showthread.php?threadid=395241
We need ...formula help 02-10-10
Would like to accomplish:
How do I add number 2 infront of the above ISSUE numbers as I have thousands
of line to do.
If your number is in column A then in column B type
=2 & A1
and copy it down.
Please rate when your question is answered to help us and others know what
> Would like to accomplish:
> 2...conditional formating #4
I have an annual report spreadsheet comprised of 15 rows (1 - 15) and 5
columns (A - E). In columns "B" and "D" I add numbers from the current
year, leaving future year cells blank. I highlight in yellow the blank
future cells in columns "B" and "D" by a conditional format "formula is =
ISBLANK(B9)". I leave past year cells in "B" and "D" with numbers but no
highlight colors. I wish to highlight in green the current year numbers in
columns "B" and "D", which will always be a cell above the firs...formatting of txt file
Can anybody can help me in in formatting the below data for me
The below data is coming in a txt file and i need the data in a excel file
However when i put in excel i am not getting any structured form
I need the Reference mentioned against the numeric value in the separate
column as heading and the data below should come below the heading. I have
tried, but i have to a lot of manual edit after formatting.
12/2 main street
City - bvauisdbc
Pin code- 1100154
oihbvis...Open Spreadsheet--Formatting Changed to Date??
I opened my spreadsheet and some, but not all of the columns on every
sheet in the workbook has changed to a date format. I opened other
spreadsheets and there was no change.
Can anyone explain this. It's a real pain to deal with.
...Display lists in an arbitrary number of columns
I have written and posted the following articles which will prove useful =
Display Lists in Columns Horizontally Using One Cell per Column
Display Lists in Columns Horizontally Using Individual Cells
Display Lists in Columns Vertically Using One Cells per Column
Display Lists in Columns Vertically Using Individual Cells
...Need Exchange limit help
I have a new SBS 2008 Server setup in a manufacturing environment. Two
users within the company send and receive large CAD files. How do I allow
this process? Right now one user is try to send a 185MB file and it is
saying "the message being sent exceeds the message size established for this
user." I have tried setting the limit in the console to 10GB and now I have
unchecked the "enforce the mailbox quotas" box and he still can't send. If
I go into the Exchange Management Console I still don't see how I can make
this work. Is this something that...COUNTIF with adjacent columns
I have a spreadsheet which has a list of tasks in one column and
directly next to it whether that task is complete/not complete/
For example in cell B2 the task is CL and in column C2 the task is
2 CL Complete
I would like to add a tally box at the bottom for all CL tasks which
are complete, then another for not complete and another for
rescheduled. At the moment, I can only get it to COUNTIF on either the
CL or the complete value but not both together.
Any help greatly appreciated!
A B C ...COUNTIF using formatting?
Here is a basic example of what I'm trying to do:
I have a list of football teams. Each week, I format the football teams
that won with red font. Is there a way to find a count of those teams
formatting in red and display that number in my worksheet?
I know an alternate way around this would be to have a win/loss column and
do a COUNTIF based on the values there. But I'm wondering if there's a way
to do it based on the formatting instead of the values.
Nicolle K. wrote:
> Here is a basic example of what I'm trying to do:
> I have a list of football team...Help with Hurricane Database
I work at the Corporate office of a fast food chain. We have almost 1000
stores in 10 states - mostly in the South. We have many stores in the
hurricane zones. During Rita and Katrina we decided we needed a better way
to track how our stores are affected and what help we could provide. I've
designed a database to do this.
I have three main tables:
fldUnit - the unit number assigned to the store
fldPr...Stop Excel Changing Format
In Excel I want to just show a date as dd/mm in a cell. Every time I enter
this Excel shows the number in dd/mm/yy format, even when I change the cell
to use the General format. Any idea how I get Excel to show the number as I
Format as dd/mm
"Chris762" <Chris762@discussions.microsoft.com> wrote in message
> In Excel I want to just show a date as dd/mm in a cell. Every time I enter
> this Excel shows the number in dd/mm/yy format, even when I change the
> to...How to split numbers and decimal in 2 columns
One column for the dollars and the other for the cents? If so, use the Text
to Columns, Use Delimited as the split option (Step 1) and select Other, type
in the decimal point in the blank to the right of the Other option in step 2.
This is good, but how do i keep it in the colums is i introduce new data and
how do i sum it up (the colums) to get a final number with decimals in there
Dollars in in B, cents in C, Data shown
Dollars Cents Cu Sum
7 56 7.56
3 44 11.00
2 24 13.24
45 23 58.47
C2: =SUM($B$2:B2)+SUM($C$2:C2)/100 and copy down
"...Outlook Certification Help
Do you need additional proof that you are an Outlook genius? Would you
enjoy the respect and additional income that could come from being able to
help everyone in your office on Microsoft Outlook? Get your Outlook
Specialist certification and realize the benefits it can have.
"Are You Certifiable (In Outlook, At Least)" is available at
http://www.linkemup.us/areyoucertifiable.htm for only $18. It will go
through each subject on the test and help you to prepare for this
certification. If you do not plan to get certified but need a little extra
help on using Outlook it is an excell...Formula for adding up columns, i.e., B1:B10 + D1:D10 + F1:F10 + H1:H10 + J1:J10
I've never figured this one out. Went and googled yet again but I'm
obviously not googling for the right thing. Same as with the help file.
What is the type of formula we use for adding up columns or rows, esp. if
they're broken up by rows/columns in between?
"StargateFanFromWork" <noSpam@NoJunkMail.com> wrote in message
> I've never figured this one out. Went and googled yet again but I'm
> obviously not googling for the right t...Font format of rich edit ctrl in dialogs, Help!
I have used a lot of rich edit ctrl in my dialogs (I am sorry that I haven't
use edit ctrl instead) and I found one problem now. The text displayed
initially in the ctrl (set by DoDataExchange()) has different font format
with the text which users type in later. Any experienced people can tell me
the functions to make these two font same? Otherwise I think I will have to
change about 100 rich edit ctrl to edit ctrl besides a lot of codes.
Thank you a lot.
...Looking for help...I can't send e-mail using CRM web client
I'm having a problem with trying to send e-mails vie the CRM web client.
When I try to send the e-mail I get a pop-up with the message in bold
"Unexpected Error" "An error has occurred. For more information, contact
your system administrator". I've checked the event logs, no errors are
showing up in either my CRM server or my exchange server.
I'm lost, new to CRM. Any help or ideas is appreciated.
You could try to add pre-windows2000 account to the administrator group on
the exchange server. Some time that helps
"Marty" wrote:...Help in Query with two condition
I have a table like this:
Planner Qty User6 CUT SUB
BAM-06 1 CONC Yes No
BAM-06 1 CONC No Yes
BAM-06 1 TOC Yes No
BAM-06 1 TOC No Yes
BAM-06 1 TACT Yes No
BAM-06 1 TACT No Yes
JAXM-06 1 CONC Yes No
JAXM-06 1 CONC No Yes
JAXM-06 1 TOC Yes No
JAXM-06 1 TOC No Yes
JAXM-06 1 TACT Yes No
JAXM-06 1 TACT No Yes
Note: CUT and SUB are check box
I want a result as follow:
User6 A B C D E F
CONC 2 2 1 1 1 1
TACT 2 2 1 1 1 1
TOC 2 2 1 1 1 1
A SUM Qty =BAM-06
B SUM Qty =JAXM-06
C SUM Qty =BAM-06 if Cut=YES
D SUM Qty =JAXM-06 if Cut=YES
E SUM Qty =BAM-06 if SUB=YES
F SUM Qty =JAXM-06 i...Help with Date format
I want to enter dates into a worksheet like this:
January 25, 2001
And i want to get excel to display the date with the following format:
I have tried using a date format from the format menu but it wont display
the date like i want! It will only display the date as I typed it in.
Thanks to anyone who can help. :)
It appears you're typing the date into a cell formatted
as something other than General.
1. Delete the current contents of the cell.
2. Format > Cell > Number tab. Choose a date format.
3. Now key in the date into the cell.