Formatting Linked Charts Now An Issue

We just got upgraded to Micro. 2003 and let me tell you it's not pretty.  I 
previously had a lengthy Word doc with a bunch of charts linked from an Excel 
worksheet I had.  Since the upgrade I had to re-link every chart because the 
links no longer work, why is this??????  Also after I cut and paste special 
as a link each chart I can no longer freely move the chart around or even 
right click to get properties and select the size I want the chart to show.  
I paste it in the right column of a word doc table so I need to size it to 
fit into the column and I can no longer do this.  This is super 
frustrating...any hints?
0
jstidsto (1)
6/12/2009 12:34:01 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
244 Views

Similar Articles

[PageSpeed] 30

Hi,

If you upgraded to 2003 what did you upgrade from?

-- 
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"jstidsto" wrote:

> We just got upgraded to Micro. 2003 and let me tell you it's not pretty.  I 
> previously had a lengthy Word doc with a bunch of charts linked from an Excel 
> worksheet I had.  Since the upgrade I had to re-link every chart because the 
> links no longer work, why is this??????  Also after I cut and paste special 
> as a link each chart I can no longer freely move the chart around or even 
> right click to get properties and select the size I want the chart to show.  
> I paste it in the right column of a word doc table so I need to size it to 
> fit into the column and I can no longer do this.  This is super 
> frustrating...any hints?
0
6/12/2009 5:34:01 PM
On Fri, 12 Jun 2009 05:34:01 -0700, jstidsto
<jstidsto@discussions.microsoft.com> wrote:

>We just got upgraded to Micro. 2003 and let me tell you it's not pretty.  I 
>previously had a lengthy Word doc with a bunch of charts linked from an Excel 
>worksheet I had.  Since the upgrade I had to re-link every chart because the 
>links no longer work, why is this??????  Also after I cut and paste special 
>as a link each chart I can no longer freely move the chart around or even 
>right click to get properties and select the size I want the chart to show.  
>I paste it in the right column of a word doc table so I need to size it to 
>fit into the column and I can no longer do this.  This is super 
>frustrating...any hints?


  You are just now upgrading to 2003?
0
RUBored (1)
6/12/2009 11:23:52 PM
Reply:

Similar Artilces:

Linking Time-varying charts
Hi all, Here's my problem. I've got a set of Excel files with monthly data which is updated every month. So in January I only have Jan data. In February I have Jan and Feb data, and so on. The chart I have for this data always displays a full 18 months data from October 2003 to March 2005, and as more data is added, the line on the chart snakes its way from left to right. These files are submitted to me from various sources. As a central data collector, I now want to link these Excel files into a single Excel file which will display all the charts in one place for convenience. Ho...

Conditional Formatting for a certain month
Having a bit of an issue at the moment, ive got the Cell for instance A1 Which contains 04-Jan-06 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 (DD-MM-YY) Thanks for any help, muchly apreciated Assuming a properly formatted date, formula is =if(month(a1)=1) -- Don Guillett SalesAid Software dguillett1@austin.rr.com "Advo" <max_mischief@hotmail.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 bold. 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...

Why Can't I Access Internet Links
I use Windows XP and IE 7 and suddenly one day I was unable to access internet links that were sent to me thru regular emails to my Microsoft Outlook. Any idea how to fix it? Thanks. What happens when you try? Any error messages? Hal -- Hal Hostetler, CPBE -- hhh@kvoa.com Senior Engineer/MIS -- MS MVP-Print/Imaging -- WA7BGX http://www.kvoa.com -- "When News breaks, we fix it!" KVOA Television, Tucson, AZ. NBC Channel 4 Live at Hot Licks - www.badnewsbluesband.com "amirstal" <amirstal@gmail.com> wrote in message news:d7decb35-157c-4438-82bd-24a2536d347f@m36g2...

Form Links
Hi All, I Was Woundering if some one could Help Me, With this rather Simple Problem I Have. I Have 2 Tables "tbl_Suppliers" and "tbl_Enquirys" Ive Managed to Achieve What i want When I Use A Tab Form and Insert a Subform on the Second Tab. What I want Is To Achieve the Same Thing With out using Tabs. So Here Goes Table "tbl_suppliers" has some of following Fields "Company Name" , "Contact Name" And "Address" and so on. Tble "tbl_Enquiry" has some of the following Fields "Company Name" , "Contact Name&q...

Adding Lines And Boxes, etc. To A Chart ?
Hello, Will blame it on my age. Using Excel 2007 (or, at least trying to) and XP. When I have a chart page opened up, how do I get it to show the bar on the bottom (that the real old versions had) that allows one to click on one of its icons shown to "draw" lines, arrowed lines, boxes, add text with a box, etc on the chart itself ? Thanks, Bob Hi, With the chart selected you can use the Insert tab > Illustrations > Shapes. To add shapes to the chart. Textbox is in the Text group of the Insert tab. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypo...

What is the basic format of a Access VBA module
Hello, I am almost completely new to Access VBA so pardon me if this question is asked before. Anyway, I came across somewhere that I have read before that before I exit an Access VBA module, I am supposed to clear the database or do something to free the database is it? May I know how it is done and why should I be doing that? Thanks! <azhu.uwaterloo@gmail.com> wrote in message news:1177681396.512608.194140@b40g2000prd.googlegroups.com... > Hello, > I am almost completely new to Access VBA so pardon me if this question > is asked before. > Anyway, I came across somewhere...

Chart Type HELP!
Hi, I still need help on the Chart Type thread that I posted a couple of hours ago under "Chart Type". It is URGENT--for a presentation for which I am already late!! Anybody?? Tx, Sat Hi Sat - Take a look at what I just posted and see if it helps. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL2K & XLXP ---------------------------------------------------------------------------- Attitude - A little thing that makes a BIG difference ----------------------------------------------------------------------...

Combination chart? Stacked cylinders and scatter
Hi, I want to make a stacked bar chart that also shows another data point as a single point along the stacked bar. Here is what I have so far '[img=http://img304.imageshack.us/img304/5372/chart7ur.th.jpg]' (http://img304.imageshack.us/my.php?image=chart7ur.jpg) Here is what I want to accomplish: - don't show Sections where Length is zero -- right now the zero sections show with label and value on the right side of the cylinders - show another data point (from another cell in my sheet) as a single point along the stacked bar - show a final data point as the total of the bar len...

Problem with line Chart
I have the following data: Date Value 1/07 700 3/07 550 9/07 600 10/07 550 7/08 500 9/08 700 2/09 750 8/09 600 I would like to create a simple line chart connecting the Value points. Note that the points correspond to random dates (not evenly spaced). How can I create a line chart that has time on the x-axis, (say shown in months) with a line connecting the Value points, which are shown at various locations in time. Soun...

rpc over https issue
I have successfully setup outlook 2003 to connect to exchange 2003 via rpc over https using basic authentication. But everytime I start outlook it prompts for a username and passwd. Is there anyway to save the credentials so I dont have to enter them everytime ? anand <anarine@gmx.net> wrote: > I have successfully setup outlook 2003 to connect to exchange 2003 > via rpc over https using basic authentication. But everytime > I start outlook it prompts for a username and passwd. > Is there anyway to save the credentials so I dont have > to enter them everytime ? No, no...

Conversion from Quicken2001 Issue
Hi, I've just bought Money 2004 Canadian version, been using Quicken 2001. Trying to convert from it, but cannot because the file is corrupt. Did the validation on the Quicken File fine, but still won't. Any ideas???? Thanks, Steve. ...

No "Chart Option" feature in the Formatting Palette or when double click on Chart
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I have read a discussion board concerning this issue but it was from 2008 and no solution was offered yet. The problem is as follows: one creates a graph but cannot add a title or format the axis etc. <br><br>When I open a new spreadsheet and enter the data, I can create the graph. However, I cannot select the &quot;Chart Option&quot; to change any specific features. On the formatting palette I only get the "Page Setup" options but nothing relating to the chart and when I double click on the graph t...

Clear Format problem
I am trying to write a macro to clear ALL format in a range of cell. However, I run into a problem. I am using the Selection.ClearFormats command and it works in most cases, but fails when multiple format are applied to the cell. For example if a cell only contains "Hello wonderful world" all in bold than ClearFormats will remove the bold formatting. But if the cell contains "Hello wonderful world" where only "wonderful" is in bold, than ClearFormats does not work and the word "wonderful" remains in bold. Does anyone know how to clea...

Formatting doesn't follow data sort
I was just recently updated to 2003 MS Office Pro. I can't remember what I use to have, but I used to be able to Data Sort info and the borders around cells would follow the appropriate text. It doesn't do that anymore, and I can't find out how to fix it in the online help, and my IT guy doesn't know off the top of his head. Can anyone help or have I wasted a full day and a half putting borders around information for no reason? -- kanimalhouse ------------------------------------------------------------------------ kanimalhouse's Profile: http://www.excelforum.com/me...

Automatic link
when i open a workbook, the warning prompts saying there are automatic link, and ask if i want to update or not. anyway to eliminate it? btw, i don't hv any url link inside the workbook. This is by design of Excel. In Excel XP you have the option to not prompt but the links will automatically udpate. The links that it is referring to are links to other workbooks not to hyperlinks. All other versions of Excel don't have this option so you would have to open the file with code to get the prompt to go away. Chris "Soe" <soenandar@hotmail.com> wrote in message news:...

Conditional links
I am trying to creat a shipping list from a set of 10 worksheets. Ther are several cells that need to be linked to the shipping list only i "x" is indicated in a particular cell in that column. I am able to ge the cell I want to link by using the following formula =IF(Sheet1!S10="X",Sheet1!E10," ") How can I list only the lines with "x"? I do not want to link only 1 line at a time. I want it to check th first line. If there is no "x" then check the next line until it find an x and then link it. Thanks in advance Cand -- CNA4 -------...

Pivot tables, linking to a named range as a source to a pivot table
I have created a main worksheet within the same workbook of many pivot tables, and I want to use this same worksheet as the source of information to these different pivot table sheets off of which I create charts. I want to use a named range because there are over 4,000 rows in this main worksheet. I am not sure if I need a "=" to start the reference or what to do. I thought I should just use nameofworksheet!database if I name the range "database", but when I point and click to the sheet, it is just inserting the name "database" without the name of the...

OWA reply shows broken link in the form area
This is a multi-part message in MIME format. ------=_NextPart_000_000B_01C5AE18.43CE9F70 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, When I reply to a message from within OWA, I get a broken link in the = areas where I would type. It's as if it can't find the form or = something. It's not a signature file problem from what I can tell. Any ideas? ------=_NextPart_000_000B_01C5AE18.43CE9F70 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC &q...

How do i get notifications of Issued Certificates thats nearly Exp
I know of certutil but havent found a guide for it and i dont know how to vbscript its so i can find Certifcates thats about to expire. ...

Cutom Time Format
I want to format a cell with a custom time format that will allow my users to type in the time without the colons. [1014 = 10:14]. I've tried several different ways of setting up a custom format to do this, but nothing works. Anybody have any ideas? Thanks! -- Sherry Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "H1:H10" On Error GoTo ws_exit: Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then With Target .Value = TimeSerial(Int(.Value / 100), _ ...

Accessing a linked file in a Word document using VBA
Hi - Basic question, in my Word template I have some linked images. I want to use VBA to change the path and filename of some of these links ... can anyone give me a clue as to how I should best do this? Thanks Robin Hi Robin, To see how to paths in Word using vba, check out the macro solution I've posted for implement relative paths at: http://lounge.windowssecrets.com/index.php?showtopic=670027 -- Cheers macropod [Microsoft MVP - Word] "Robin" <Robin@discussions.microsoft.com> wrote in message news:7EA2C548-7D01-4515-BCC8-2EF3210439C9@microsof...

Random connection issues!
Hi All, My cust has random connection issues with the Microsoft Outlook Connector (MOOL). Is there any reason why this could happen? Here is what the log file states: Outlook Connector Version 1.6.1601.0 Account: jrcarrizo@hotmail.com Session timed out. Automatically re-signed in at 5/10/2005 08:31:14 Mail: Error at 14:45. Last successfully refreshed at 10:43. Calendar: Error at 14:43. Last successfully refreshed at 10:43. Contacts: Error at 14:43. Last successfully refreshed at 10:43. Errors : Time: 5/10/2005 11:31:17 Error in Mail Network operation failed Time: 5/10/2005 11...

Ignore deductions linked to Direct Deposit to calc Net Pay
When an employee has a deduction linked to direct deposit and another deduction that is a percentage of net pay (ie. garnishment of wages), the amount of the second deduction is less than it should be because the direct deposit deduction is reducing 'net pay.' Since the direct deposit deduction really IS net pay, other deductions should be based on the net pay before deductions linked to Direct deposit. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree&qu...

How to credit complicated pie chart
I want to create a pie chart of my credit card statement each month. Every pie chart example shows 3 columns and about 5 rows of data. I can create a chart for something that simple but what I need is A chart showing the amounts and to what merchant that amount was spent at. Can someone point me in the direction where I can find something that would tell me how to do what I want? Thanks Ron ...