Make lines on a graph appear with a button
I need to create a graph with 40 or so lines graphed but only one up o
the graph at a time with the use of buttons. I would really appreciat
a hand, I am very new to this level of Excel. Thanks
Message posted from http://www.ExcelForum.com
Select all the data, and create a line chart
Select a cell in the table
From the dropdown list in one of the heading cells, select an item
The chart will display the data for that item
geistritter < wrote:
> I need to create a graph with 40 or so lines graphed but only one up on
> the graph at a tim...XY scatter graph
How do I attach dates to data points when the x&y values are not dates?
One way is to use Rob Bobey's free addin, Chart Labeler.
gps tech wrote:
> How do I attach dates to data points when the x&y values are not dates?
Andy Pope, Microsoft MVP - Excel
I run XP and am attempting to run the following high-priority update:
Microsoft .NET Framework 1.1 Service Pack 1 Security Update for Windows
2000, Windows XP, Windows Vista, Windows Server 2008, Windows 7, and Windows
Server 2008 R2 (KB953297)
I cannot do so, receiving the following Error Code: 0x66A
> I run XP and am attempting to run the following high-priority
> Microsoft .NET Framework 1.1 Service Pack 1 Security Update for
> Windows 2000, Windows XP, Windows Vista, Windows Server 2008,
> Windows 7, and Window...Outlook DST update
Can this update be done at the server level? Or do I have to touch each
The OS needs to get its KB 931836 Feb. 2007 cumulative time zone update.
Rebasing can be done either on the client-side using the Outlook Calendar
Update Tool (aka "Time Zone Update Data Tool for Microsoft Office Outlook"),
or as a bulk operation by an admin using the Exchange Calendar Update Tool,
which in turn calls the Outlook Calendar Update Tool and rebases items for
each user specified in an input file.
DST 2007: Understanding what needs to be done and how to do it
How do i make a graph predict the next value from 3 tables with info
eg Table 1 has 5$ profit
Table 2 has 3$ profit
Table 3 has 8$ Profit
how do i make a graph which predicts the next set of values from these
peabushmartin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27399
View this thread: http://www.excelforum.com/showthread.php?threadid=469414
The mechanics of getting a chart to predict future values is easy.
Chart your data in the desi...Microsoft CRM v1.2 Update: 840934 and another language
I need update 840934 for Polish language.
...Graph within a graph
I am looking to have a pie chart show general information and then have
another pie chart show a section of the origional in greater detail. Is this
Have you tried using a Pie in Pie chart?
"Jen Kulak" wrote:
> I am looking to have a pie chart show general information and then have
> another pie chart show a section of the origional in greater detail. Is this
That is what I am trying to figure out how to do. I know where the option
is, but for some reason I cannot figure out how to enter the data correctly.
"Barb R." wrote:
&g...Computer Check updated GL but not Check book
We have an issue with payables computer checks, the check is posted in
payables module and properly updated both GL and sub ledger but the
checkbook register is not showing this check under payments. We found
that trx source is missing for this document in payables and the audit
trial code is mentioned as 1 in journal entry where as it must start
with PMCHK which is the source code defined in audit trial code setup.
Can somebody resolve this issue?
Thanks in advance
Looks like you had a glitch. When the Trx source is blank in the payables
file that usually means the tr...Conditional Formatting Dates 02-18-10
I am attempting to highlight past due dates (I am horrible with the formula's
and can not seem to figure out how to NOT highlight if there is no
information in the cell's)
A1=Planned date and A2=Completed date
Conditions I am trying to figure out
1. Would like A1 to highlight RED if less than Now and A1 is NOT BLANK or A2
2. Would like A2 to highlight green if filled out and less than or equal to A1
Thanks anyone that can help!!!
CF formula for A1:
CF formula for A2:
How can I create a graph that would show sales/dept on
the Y axis and years or months on the X axis?
use a pivot chart/table in excel. You must create a datasource forst.
"irene" <firstname.lastname@example.org> wrote in message
> How can I create a graph that would show sales/dept on
> the Y axis and years or months on the X axis?
I have problems with Excel when there are tons of graphs i hve to create with all the graphs being on one page. Having to resize all of them when they are all ALREADY different sizes is a pain. I know how to hold down the control key and select them and resize them all at once, but some or still larger than others unless i resize them individually. Is there a way to make them all the same height adn width some how? or is this just a dream? Must i resize all of them individually?
I personally use an add-in (.xla) which includes the following code (you can
pick up the size of a chart with ctrl...How to programmability format a removable drive?
I am working on an image presentation system that ingests images from
memory cards. I need to give the user the option to "format" the
memory card once the images are copied to the computer. The question
is: How do I very quickly clear or format the memory card
Browse this thread:
This posting is provided "AS IS" with no warranties, and confers no
How do I format cell allowing only number entry and give message fo
Thanks in advance for your help
Message posted from http://www.ExcelForum.com
Use Data | Validation | Settings Tab | Allow: Whole number or Decimal. Then
add a message to the Error Alert tab
"Kim-Anh Tran >" <<Kim-Anh.Tran.email@example.com> wrote in
> How do I format cell allowing only number entry and give message for
> Thanks in advance for your help!
> Message ...How to do bulk updates.
I have imported data into various entities and now want to do tidy up the
data by setting default values for picklists etc.
I know I should have done this on the import but what is the easiest way to
do this on existing records. Will a Work Flow cover this? If so what kind of
Work Flow do I need to setup.
Thanks for your help.
To do Bulk Updates, select the records you want to edit and then select Edit
from the More Actions menu. This will present you with a blank form. Changes
you make to this form will be applied to all the records selected.
Larry Lentz [CRM MVP]
MCSE+I, MCS...Weird date format problem
Our minor hockey organization uses Excel 2007 to create hockey schedules.
for some reason the first half of the schedule has some kind of date format
in column A that shows the date as D/M/YY not matter how you enter it. Then
it changes to MM/DD/YY about 20 rows down and no matter how many different
ways I have tried to change the formatting it still comes out the same month
after month. I go back and reenter the d/m/yy dates to shows as mm/dd/yy but
it leaves off the preceding zero on the month and I have even try to use
paste formatting command to fix it and it doesn...Creating a Line graph
I have data that I want to put in a simple line graph: The data is
I mark the 6 cells, select insert chart / line and get a chart with both A
and B labels on the x axis. I go to "select data source" and try "switch
row/column" and get A and B as series names in the legend. How do I get the
label A and the values 23 and 87 on the x axis, and label B and values 200
and 500 on the y axis please?
(Congratulations Microsoft for making something that was so easy and
powerful in Excel 2003 an absolutely primitive disgrace...The Reliable Source for Everything XML
The Reliable Source for Everything XML - XML 2005 Update
XML 2005 - November 14-18 - Atlanta Hilton Hotel - Atlanta, GA
Register today and participate in IDEAlliance's XML 2005 Conference,
the most respected educational gathering of technologists, novices,
experienced implementers and users, consultants, and innovators to
share knowledge and experiences, gain insight, and initiate new
advancements in XML and related standards. XML 2005 is "the reliable
source for everything XML".
XML 2005 is five jam packed days of educational tutorials, high-level
keynot...Updates from bank incorrect
I have Money 2006 Deluxe and I bank with Capital One. When I download the
updates for the account, I have 2 different problems.
The first problem is that the system downloads transactions that were
already downloaded 2 or 3 days before.
The second problem is that the system keeps assigning the wrong Payee to
some of the transactions. Because the system assigns the Payee, it is greyed
out and there is no way to change it.
Occasionally these two problems overlap in that the duplicated transaction
is also assigned to an incorrect Payee.
I have deleted Money 2006, rebooted, and have re-...Update a value in an XML column
I have an XML field in a table and want to update values in the XML.
Can somebody point me to where updating a field in XML is actually
TIA - Jeff.
"Mr. Magic" <Mufasa@NoWhere.Com> wrote in message
>I have an XML field in a table and want to update values in the XML.
> Can somebody point me to where updating a field in XML is actually
In what way are you trying to update it? I mean the standard UPDATE
statement does the trick pretty easily if your update i...Graphs on Forms
I am having a problem getting a graph to display the variables along
the right axes. The graph sits on a form which is linked to a parent
query. The graph's information comes from a separate crosstab query
that is linked to the form via fields from the parent query. The
graph fields are day (horizontal axis), race time (Y-axis) and race
distance (series field). Unfortunately MS Graph automatically plots
the day field as series and the race distance on the X-axis despite
the fact that in the crosstab query, I have assigned 'day' as a column
heading, 'race distance' as ...Subtotals Formatting
Is it possible to change the formatting of a set of
subtotals such that they for instance could be displayed
in red to make them stand out, without having to change
each individual one?
One way is to show the detail you wish to change, then use Edit/Go
to/Special/Visible cells. This will select all visible cells only, which you
can then format as you wish.
"Simon Topping" <firstname.lastname@example.org> wrote in message
> Is it possible to change the formatting of a set...joining data points on graph
I am merging two graphs and one has 23 data points, the other has 9. The
category axis will have 23 data points but the 9 points are spread out, i.e.
they may be at points 1, 3, 7, 15 etc of the 23-point scale. At the moment
the graph will only join points that are beside each other; how do I get them
to connect to the points that have spaces between them?
minihana wrote on Fri, 10 Feb 2006 11:29:04 -0800:
m> I am merging two graphs and one has 23 data points, the
m> other has 9. The category axis will have 23 data points but
m> the 9 points are spread out, i.e. they may be...Credit Card updates
I have 2 credit card accounts in MS Money 2007 that are not setup for online
updates, yet every time I restart Money it creates another account and tells
me that I have duplicate accounts. It would create the new account with the
same name and add #2 and #3 and so on. Any ideas on how to stop this from
In microsoft.public.money, Darrell B. Parker wrote:
>I have 2 credit card accounts in MS Money 2007 that are not setup for online
>updates, yet every time I restart Money it creates another account and tells
>me that I have duplicate accounts. It would create the ...Turn off automatic date formatting?
Is it possible to turn off the automatic formating of certain cell entries
For example if I type in 6-10 (meaning six to ten), Excel presumes a date
was entered and 6/10/2005 is entered and displayed as 6-Oct.
An other example is 04/05 (meaning the financial year 2004/05), excel
presumes a date and enters 4/05/2005 and displays 4-May.
I know its possible to enter these values other ways (eg
=concatenate("6-10")), but is there a way to "turn off" this automatic coding
into a date.
Thanks, any help would be appreciated.
Format the cell / range (ri...Time format
i am trying to change the format for one of the columns in my query.
basically, i would like:
"1/6/1900 4:46:25 PM" to read as "160:46:25"
"1/2/1900 3:43:31 AM" to read as "51:43:31"
using field properties, what is the format that i can use to generate this
Thank you for your help !
>i am trying to change the format for one of the columns in my query.
>basically, i would like:
>"1/6/1900 4:46:25 PM" to read as "160:46:25"
>"1/2/1900 3:43:31 AM" to read as &q...