Cutting a line in a line chart when data series stops
I have a series like so:
And so on - the rest of the year is blank. When I draw a line chart for the
full 12 months the series draws a line up to April, then plummets to zero in
May. I want the line to just stop at April. If I use a series as above and
genuine empty cells for the end of the year this ok, but since my May cell
reads =IF($A11<=$D$17,G11,"") the "" does not seem to get recognised as a
Change your formula to =IF($A11<=$D$17,G11,NA())
"DannyS" <Da...Money 2007 -- QIF import
After a little trial and error, I am able to import account transactions
from another system (not a bank statement, my actual register transactions)
with little trouble except for the date format.
(Before someone gets mad at me, I really don't think this has anything to do
with my regional settings!)
As recommended by an MVP from this forum, I open my CSV file with excel,
then use a converter (add-in) called XL2QIF to create a qif output file.
The actual "data" in a date field in my original csv file is "060106"
(mm/dd/yy) which is June 1, 2006,...All charts in gray color
In SharePoint Sever after I upload a excel file all my charts are
displayed in single gray color, not even a different tones of gray
just one tone, any idea how to correct that behavior?
Thanks in advance
...Time without date
I'd like the current system time displayed in a cell when I press 'enter'
Only command I know is =NOW() which displays the date and time in a cell.
How do you display only the time? AM PM Doesn't matter.
I've tried looking it up in help but can't but can't seem to find the answer
to my question.
and format as hh:mm:ss
"Mickey Mouse" <.> wrote in message
> I'd like the current system time displayed in a cell when I press 'enter'
&...Entering Todays date in an excel spreadseet
This is a multi-part message in MIME format.
I have a need to automatically save the current date to a cell in an =
excel spreadsheet every time the sheet is saved.
Today() always returns the current date, so once I open the sheet on a =
new day I can no longer see the date the information was last updated, =
Any help would be appreciated.
charset="iso-8859-1&q...How to erase a line drawn using line bar next to + = bar
I drew a line to separate text but now cannot get rid ot it. When I edit or
move the text the line keeps reappearing even if the text is cut and pasted
it moves with it, or stays with what it left
Microsoft Word MVP
"janetland" <email@example.com> wrote in message
>I drew a line to separate text but now cannot get rid ot it. When I edit or
> move the text the line keeps reappearing even if the tex...date formatting 03-22-10
I have an excel sheet which has a date in yyyy/mm/dd format saved on the
internal network. other users who open the file do not see this date as the
same format as the saved file. could anyone provide as to why this is
happening and what can be done to correct it.
Sounds like you have not specifically formatted the cell as yyyy/mm/dd.
When you don't specifically format a date cell, Excel will look at your
Windows default setting and use that, so you will see a date as yyyy/mm/dd
and someone else will see it as mm/dd/yy depending on their windows setting.
T...Date input mask
I have a form that has several date input mask: 99/99/0000;0;_ . I have them
auto tab to the next field. Lately after putting in all my data I copy and
paste into an excel spread sheet. Then I find out that some of the dates
have 208 instead of 2008. I don't know how this can happen since I have to
put in 4 digits in the year. I did do some testing and once in one of the
fields it did put in 208 in the year part of the year. I think I put in
01/25/2008. If I try to only put in 3 digits I get an error message and it
won't let me go on. Any idea? I didn't have this pr...Basic Exchange Front End Server Questions
Doing a FE Exchange install for the first time and had some basic questions
before I start.....
Does the FE Exchange server need to be added to the domain?
Does the binding order of the network cards matter?
Should I bind the BackNet (internal network) to be accessed first or the
FrontNet (external network).
Should I take off File and Printer Sharing for MS Networks and Client for MS
Networks from the FrontNet (external network)?
And finally... under Advanced TCP/IP Setting of the FrontNet (external
network) should I disable Register this connection's addresses in DNS and ...how do I show filter information on a pivot chart in excel2007?
In the previous version of Excel that I used you had the option to show Pivot
Chart buttons which detailled how the chart had been filter. I can't find a
replacement for this in 2007 so if someone prints the chart it isn't
comprehensive in that you can't tell how it's been filtered. I create a lot
of these for less experienced users and this info can be critical since
descisions are made based on these charts. Can anyone help please?
See the reply to my question about the same issue (added 16/9).
That works. You just need to modify the macro for every s...How can I add values from several worksheets in a line chart seri.
I have an Excel document with 12 (monthly) worksheets. I want to make a line
chart pulling data in one cell (same cell on each sheet) from each of the
twelve sheets. In other words, Jan F2 + Feb F2 + Mar F2, etc.
Can I do that on the chart's Source Data menu in the Series/VALUES field? If
so, what is the proper language/formula. If not, what are my options? Do I
have to make a total page and pull from it?
Also, is it possible to make the Category (X) axis label be the Worksheet
Name (Jan, Feb, Mar)
Lastly, is there a place that gives sample formulas for someone trying to
brush...[Entourage 2004] Show me the date!
How can I force Entourage 2004 (SP2) to sort mails by received and
at the same time show me the receive date instead of weekday and
It doesn't work to disable 'Use relative dates in lists (Today,
Yesterday)' in General Preferences > General. It still shows me
weekday and time instead of the date.
Under the "View" menu, set "Preview Pane" to "Below List" or "None". If the
Preview Pane is set so that it is "On Right", the message list will always
use relative dates. I agree that it is an unfo...Everytime I email a spredsheet, the receiving end cannot open it
The person on the receiving end cannot open the spread because it is
encrypted. I just upgrade to office 2007. I do I turn this feature off?
Two known solutions:
1) Save the WB as "97-2003" (xls) instead of XLSX.
2) Ask the recipient(s) to install the Compatibility Pack:
> The person on the receiving end cannot open the spread because it is
> encrypted. I just upgrade to office 2007. I do I turn this feature off?
...overcoming zero values in line graph
I have a 12-month line graph where some of the earliest and most recent data
is still zero.
Is there a way to have Excel not plot zero values - to avoid the big rises
and drop offs they cause - and, rather, just have the graph start and end
wherever there is positive data?
(NOTE: for multiple reasons, I can't erase the formulae in the cells
yielding the zero values, or have them display the N/A message....)
There is no reason why you cannot have a 2nd data set that has the N/A
values. Plot this second set and use the first for whatever you are
using it ...Chart's DataTable
Some times we need to show source data with chart. we could turn it
true by use specific name in axis(xlcategory) or by using source data
's linking picture . Both of these could help us to show specific
and as all of us know that, the chart's datatable will show all of the
I want to know whether we can hide any dummy series in chart's data
Thanks for your answer in advance.
No. Formatting, including hiding, of chart data table elements is very
This may help
http://tushar-mehta.com/excel/newsgroups/data_table/index.htm...How to have a date range equal a particular month
What is the expression for converting multiple dates mm/dd/yyyy to the
It is according to how you are going to use the data but try this --
This will give you 200711 for this month.
Format([YourField], "mmmm yyyy")
This will give you November 2007 for this month.
Build a little - Test a little
> What is the expression for converting multiple dates mm/dd/yyyy to the
> coinsiding month?
Format(DateField, "yyyy-mm") as stri...Creating a calculated field using dates in a form
I am trying to use dates from 2 fields in a form (HireDate-DOB) to calculate
age. Then, using the age, I want to display a message if the age is less
than 18. I think I have written a conditional statement correctly, but am
unsure where to place it so that the message displays when the condition is
I am totally new to Access 2007 and VB.
You did not say what the content of your 'conditional statement' was and how
you plan on using it.
What has HireDate to do with it? Is it you want to see if their age is
less than 18 on the date of hiring? Then this will c...How do I remove multiple line feed(s) or carriage return(s)?
I have carriage returns in a column as follows:
address1 CR city CR state CR zip
address1 CR address2 CR city CR state CR zip
I need the city, state and zip to end up in the same column.
Can you help?
You mean you want the city in its own column, the state in its own column and
the zip in its own column?
And your data always has 3 or 4 CR in the cell?
If yes, then (assuming the data is in A1:Axxx), then put this in B1:
(and ...wrap text in a chart data table #2
Im have created a graph, which ive had no problem, but i when i click the
option to "show data table" i cannot get the titles to wrap to the box, i
have searched but i cannot find an option to wrap the text as i need it for a
I do not want to just simply alter the font size if possible. Is there
anyway of doing this?
...Count cells in a column that contain dates
Column J contains dates in some cells, and text in others. I need to count
the number of cells in this one column that contains dates. How can I do
If the only cells that are in that column that are numeric (like dates), you can
(Dates are just numbers formatted nicely in excel.)
> Column J contains dates in some cells, and text in others. I need to count
> the number of cells in this one column that contains dates. How can I do
...Chart line colors
I create a few charts in code from VB.NET using the excel interops, office
2003. In my software I need to be able to set the color of the lines i.e.
the color of each series on the chart. There may be up to 9 series per
chart. How do I asign a color to the series lines on the chart?
Get out your version of Excel, make a chart like the one your code will
produce, then record a VBA macro while you change the series formats
manually. Then all that's left is to translate the VBA into VB.Net.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solut...Chart background color not copying along
I have a problem with charts that are placed on seperate chartsheets within
my workbook. The chart-area is filled in different of yellow with a
fill-effect. No problems thus far. But now when I'm copying the chart to
word, the background-fill is reset to a black/white scheme instead of yellow.
Strange behaviour that didn't occur up till november 2008.
I've been researching this for a while. Up till now I found the following:
This only happens when the chart is on a seperate sheet, not when it is
positioned on a worksheet.
It only happens with fill-effects.
The color-swit...iFrame and dates
I'm trying to fill in a crmForm that has a date type field, from an iFrame.
In the codebehind of the iFrame's aspx I'm using
"parent.crmForm.all.<fieldname>.value=data where data is a CrmDateTime value,
but the field does not appear.
...Move to end of edit
I have an edit box in a grid edit dialog that opens when I type a
if(nChar > 0)
dlgGrid.m_strEditCell = (TCHAR)nChar;
The character is selected but I want to deselect it and position the
cursor after the character. How do I do that?
Steve Wolstenholme Neural Planner Software
EasyNN-plus. The easy way to build neural networks.
On Sun, 18 Jun 2006 16:04:21 +0100, firstname.lastname@example.org wrote:
>I have an edit box in a grid edit dialog that opens when I type a
>if(nChar > 0)
> dlgGrid.m_strEd...Buying a mutual fund with a 5.75% front end load.
Nothing I'm doing seems to be giving me sensible answers. I assumed I'd take
the purchase price time 5.75% and put that in commission. Or, do I jack up
the purchase price by 5.75% and then take that amount back out in
Thanks in advance,
In microsoft.public.money, Harold Morgan wrote:
>Nothing I'm doing seems to be giving me sensible answers. I assumed I'd take
>the purchase price time 5.75% and put that in commission. Or, do I jack up
>the purchase price by 5.75% and then take that amount back out in
I would enter the numb...