Graph formats after updates

I am trying to keep a set of graphs linked in a document to their excel file. 
 The problem is that I cannot select the option to keep them the same size 
and format when they are updated.  The option is greyed out.  Please help me!
 

0
fcisp (2)
6/24/2005 2:31:02 PM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
619 Views

Similar Articles

[PageSpeed] 42

Reply:

Similar Artilces:

Make lines on a graph appear with a button
All, 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 Choose Data>Filter>AutoFilter 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? Hi, One way is to use Rob Bobey's free addin, Chart Labeler. http://www.appspro.com/Utilities/ChartLabeler.htm Cheers Andy gps tech wrote: > How do I attach dates to data points when the x&y values are not dates? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info ...

update issues
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 Help! -- IanS IanS wrote: > 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 Window...

Outlook DST update
Can this update be done at the server level? Or do I have to touch each machine? TIA Eric 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 http://exchangepe...

Prediction Graphs
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 values? -- peabushmartin ------------------------------------------------------------------------ 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 possible? 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 > possible? 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
Hi, 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 Regards, Satya 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 is BLANK 2. Would like A2 to highlight green if filled out and less than or equal to A1 Thanks anyone that can help!!! Katie CF formula for A1: =OR(ISBLANK(A2),AND(A1<TODAY(),ISNUMBER(A1))) CF formula for A2: =AND(ISNUMBER(A2),A2<=A1...

sales graphs
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" <anonymous@discussions.microsoft.com> wrote in message news:260801c5113c$6dd4a6d0$a601280a@phx.gbl... > How can I create a graph that would show sales/dept on > the Y axis and years or months on the X axis? ...

Resizing Graphs
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 programmatically? Cartopre Browse this thread: http://groups.google.com/group/microsoft.public.win32.programmer.kernel/browse_thread/thread/d46a7e2b862560a0/915aa8407dbdb1f7?lnk=gst&q=format#915aa8407dbdb1f7 -- V. This posting is provided "AS IS" with no warranties, and confers no rights. "Cartoper&q...

Cell format.
How do I format cell allowing only number entry and give message fo retry? 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 Regards Trevor "Kim-Anh Tran >" <<Kim-Anh.Tran.15jntm@excelforum-nospam.com> wrote in message news:Kim-Anh.Tran.15jntm@excelforum-nospam.com... > How do I format cell allowing only number entry and give message for > retry? > 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
Hi 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 A B 23 200 87 500 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 www.xmlconference.org 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 understandable? TIA - Jeff. "Mr. Magic" <Mufasa@NoWhere.Com> wrote in message news:ePwVdoR0KHA.3584@TK2MSFTNGP06.phx.gbl... >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 > understandable? 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
Hi, 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? Cheers Simon Simon 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. Andy. "Simon Topping" <anonymous@discussions.microsoft.com> wrote in message news:099501c39fb5$dce555a0$a601280a@phx.gbl... > Hi, > > 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 happening?? 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?
Hi Is it possible to turn off the automatic formating of certain cell entries to dates. 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. hi Format the cell / range (ri...

Time format
Hello, 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 result ? Thank you for your help ! -- larry larry wrote: >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...