Show decrease in gap time in a line graph
Hi, I'm trying to show that my time needed to fill new positions is
decreasing. The data I have is the date a new employee is requested, the date
I hired someone, and the number of days in between (gap). Any help would be
I think I would put the request date in one column, and the number of days
to process the hire in the next, and make a line chart of this data.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"a0xbjzz" <firstname.lastname@example.org> wro...Subject Line Does Not Appear
All of a sudden, when I go to send an e-mail, there is
no place to enter the subject. All I can enter is the
destination address, and, of course, the body of the
I cannot find a setting for this anywhere in options.
TIA for your help.
When in a new mail item go to the View menu & select Message Header.
"Ken Gunton" <email@example.com> wrote in message
> All of a sudden, when I go to send an e-mail, there is
> no place to enter the subject. All I can enter is the
> destination address, and...how do i copy/paste in excel without pasting hidden lines
I've got a spreadsheet with various rows hidden but when i highlight and copy
into another ss it also copies all the lines i've hidden. I'm sure there
must be a way to only copy the lines i want!
> I'm sure there
> must be a way to only copy the lines i want!
There is. Select the rows you want to copy including the hidden ones then
tap F5 - Special - Visible cells only OK and then right click and copy and
you only have the visible cells
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumpti...ERROR saving Grid as XML
I have a Grid and I want to save the values on an XML.
Let me say that I am NOT using DataSet to load valus on my grid.
When I am saving a Grid to XML I get the following exception:
"Token StartElement in state Epilog would result in an invalid XML
myXmlTextWriter = new XmlTextWriter (aFileName, null);
myXmlTextWriter.Formatting = Formatting.Indented;
myXmlTextWriter.WriteStartElem...Publisher 2003 Line spacing
I'm reasonably new to Publisher but am getting there.... however, I'm
struggling with something that's probably really simple to address. I've
pasted articles from Word into Publisher and the bottom line of each
paragraph is spaced differently to every previous line in the same paragraph
- there seems to be additional space above the letters.
I seem to have tried everything to resolve this - justification, line
spacing, baseline guides... nothing seems to help. It's maybe none of those
things, or maybe it is but I've not understood properly what I ne...set Curved lines as default for Connector tool.
Is there a way to set "Curved Lines" as the default for the "Connector
Now I have to draw the line with the default setting of "Straight Line" then
change it to a curved line.
I am using the Detailed Network Diagram template.
When you first use the Connector Tool, a master called Dynamic Connector is
created in your Document Stencil.
Open the Drawing Explorer Window
Expand the Masters branch
Right mouse the Dymanic connector master
Select Edit Master
Change the line to Curved Connector
Close the Master Edit window (accept changes)
T...remove line breaks in word 07
I want to remove line breaks in word 07 without doing each one manually. All
that I've found seems to apply to Excel or older versions of word. Is there a
way to do it with this version?
Thanks in advance.
Line breaks or paragraph breaks? See
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <&...Signatur Lines
How to make signatur lines only on return sales??
...command line usage
How do you hide a receipient form the GAL and set the
Information storage limit to zero from the command line?
The only way to do this would be to script it, and this depends on what
version of Exchange you use.
Microsoft Exchange MVP
"JJ" <firstname.lastname@example.org> wrote in message
> How do you hide a receipient form the GAL and set the
> Information storage limit to zero from the command line?
>The only ...WORD: Change default font, paragraph and line spacing
Running Windows 7 Pro with Office 2007 Enterprise. I need to change the
default font to Tahoma; line spacing to single; with no paragraph space on
normal style paragrah for new all documents.
I have been doing this for years. Open Font Dialogue Box - set font size etc
and clicked the dault button and OK. Easy as falling off a log. The same with
line space and paragraph spacing setting - Open Paragraph Dialogue box -
change settings and click default. This is not working on my Windows 7 HP
I then thought I would change the Normal Style and set it "For all docum...Cannot eliminate double line spacing
When composing an email message in Outlook 2007, especially when formulating
a reply, the <Enter> key continually inserts a double-space at the end of a
line. To resolve the problem, we highlight the text and choose
single-spacing from the 'Text Formatting' options, but the double-spacing
persists. Has anyone else experienced this problem and do you have a
solution? We have expereinced this frustrating behavior through multiple
versions of Outlook.
Blue Max <email@example.com> wrote:
> When composing an email message in Outlook 2007, especially when
> ...How do I set up a way to add up the number of lines used when cal.
I am doing a worksheet. On this chart I want to track the price of an object
sold. Along with that I want to add up the number of the objects that have
been sold, by just adding up the number sold in a column. Is there a way to
do this, beside creating another column and putting a qty in it.
It sounds like you want to use =countif()
(if each object is singular)
If you have quantities, maybe using =sumif()
Debra Dalgleish has some nice counting/summing instructions at:
>...Line charts with missing data points in Excel 2007
The data points will not connect in a line chart due to missing data in
between. I see a thread where you can solve this problem by selecting the
interpolation option in Tools menu > Options > Chart tab. But I can not find
this Chart tab options under Excel option in Excel 2007. Could someone
please tell me how to deal with this problem in Excel 2007? Thank you very
Right-click a point of the data series, choose Select Data from the shortcut
menu, on the Select Data Source dialog box click Hidden and Empty Cells,
click (Show empty cells as:) Connect da...Syntax error with WinDBG command line -c ".cls;g"
I am using WinDBG 18.104.22.1683 to debug a target (VMWare ware guest)
over COM pipe. I intend to pass a command line that clears the screen
and continues debugging. So, I pass -c ".cls;g" and I get the syntax
Processing initial command '.cls;g'
0: kd> .cls;g
^ Syntax error in '.cls;g'
It works fine if pass just -c ".cls"
WinDBG help states that "If you are starting a debugging client, this
command must be intended for the debugging server. Client-specific
commands, such as .lsrcpath, are not allowed. ". Is that wha t...How do I convert a line chart to a vertical line chart in Excel
yr_2007 yr_2008 yr_2009
spring 20 75 35
summer 60 25 80
fall 55 40 100
x : year
y: value of count
want convet to:
x: value of count
If I understand you correctly, a XY Scatter chart would be the more
appropriate chart. Even though it and the Line chart look similar,
the former offers a numeric x axis.
On Wed, 19 Aug 2009 20:09:01 -0700, Gerty
> yr_2007 yr_2008 yr_2009
>spring 20 75 35
>summer 60 25 80
>fall 55 40 100
>x : year ...Delete Email from OUTBOX with certain Subject line
Hello all, I hope that someone that reads this can help me. I am
attempting to remove ALL emails from the outbox with a certain subject
line (We send emails with a 10min delay to the outbox with subject
"Please Acknowledge Issue") where can I find assistance with this?
Press Ctrl Shift F to invoke Advanced Find window
Go to Outbox - sort by Subject line
<firstname.lastname@example.org> wrote in message
> Hello all, I hope that someone that reads this can help me. I am
> attempting to remove ALL emails from the outbo...Special line graph effect
I'm trying to create a line chart that, beyond a certain point, gives an
increasingly widened line to indicate uncertainty when extrapolating into
the future. I've created a temporary link to a graph from a Bank of England
inflation report which has the effect:
Not sure if this is possible in Excel but would appreciate any help
You can achieve this effect by combining a line and area chart.
set your first area series = the lower bound of the projected range
and your second area series to be the difference between ...Constant number of lines per group
I need to print a constant number of lines per group, as my report
needs to print on pre-printed forms, and the data needs to land in the
correct location on the paper.
I found the following support article on Microsoft's web site, but it
indicates that it works only through version 97. Hoping it would
still work anyway, I followed the instructions, but it did not work
for me in Access 2007.
Does anybody know how to accomplish this in 2007?
"... did not work ... in Access 2007" does not tell us much.
Did Access print anything?...Still frozen out of On-line clip art--PLEASE HELP!
I'm sorry, Mary--I tried what you told me--NOTHING works. I'm starting to
panic as I use the office on-line clipart constantly. The only step I didn't
try was deleting the Office cookie because I don't know how to do that. I am
not a technical person. In addition to being frozen out of Office on-line
clip art, I am not able to engage a hyperlink. I get the same message each
time: "Unable to open. Cannot open specified file". I can't understand why
everything was working fine a couple of days ago and now everything seems to
be locked up. I even foun...Editing Paragraph Line Spacing using macro; need help
I have the following code which should, but does not, change paragraphs that
have exactly 24 or 12 pt spacing.
Can you advise me as to what is wrong with the code? I can't find anything
that addresses the issue in an if statement. I hope someone can help.
'2. If the paras is set to exactly 12 points
' then make the spacing single spaced.
' If the paras is set to exactly 24 points
' then make the spacing double spaced.
Dim par As Paragraph
On Error GoTo NextPara
For Each par In ActiveDocument.Paragraphs
If par.L...Aligning lines in a chart
I have a chart created from three different worksheets. They are lists of
defects grouped on dates, and each sheet contains one status.
The x-axis has dates, the y-axis has number of defects.
The problem seems to be aligning the different lines from these worksheets.
The groups are not on the same dates, so I have three tables that can look
like this (only first three, sorted):
Date New Defects
Date Fixed Defects
Date Closed Defects
29....Line chart: Dates in uneven intervalls on x-achsis #2
'Supplementary' questions: Is there a clever way to make excel recogniz
that '3 months' stands for '0.25 years', and '6 months' stands for '0.
I know, this is only cosmetics. Nevertheless it would be interesting
gdavids's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1589
View this thread: http://www.excelforum.com/showthread.php?threadid=27378
You could use a helper column that divides months by 12 to scale as years.
Jer...Leader Lines in Excel?
Does anyone know if it is possible to create Leader Lines
in an Excel worksheet, like the way you can in Word
(using Tab Stops)??
It depends what you're trying to do, but some variation on the following
1. Enter a value in A2, and the other value in C2.
2. In cell B2, type the character you want as the leader, e.g. a period.
3. With B2 selected, choose Format>Cells.
4. On the Alignment tab, under Horizontal, choose Fill
5. Click OK
> Does anyone know if it is possible to create Leader Lines
> in an Excel worksheet, like the way you can in Wo...I want to find the lowest point on the plotted line in a graph.
I want to find the lowest point on the plotted line in XY
(Scatter) graph. I have many points scattered above and below the line. I
need the lowest point on the line and not the lowest point on the graph.
We need more detail about the line and your data points?
Is the line a simple horizontal line, a slope or a undulating line?
Andy Pope, Microsoft MVP - Excel
"Edwin" <Edwin@discussions.microsoft.com> wrote in message
> I wa...Best grid for data...
I have to use a grid to display data. The data is not
from a database and hence I cannot use data bound grids.
Now, there are so many grids that Iam totally confused
which one to use.
For now, I just have to display information and sort the
rows in ascending/descending order when the user clicks on
the column header. This can be achieved even by MS Flex
grid. But Iam looking for a grid that is flexible and
extensible in case there are new requirements like editing
Can somebody help me find a good grid? Ofcourse Iam
looking for freeware.
thanks for your patience.