Excel has stopped showing graphs on seperate chart tabs

All chart only worksheets appear as the vacant background (as if no file is 
open) yet the worksheet tabs are all visible.  Charts embedded in a worksheet 
show OK.  This applies to all files created or historic 97-2003 type files.  
What's causing it and what can I do?
0
JonesyAD (1)
9/13/2007 4:22:01 AM
excel.charting 18370 articles. 0 followers. Follow

0 Replies
710 Views

Similar Articles

[PageSpeed] 34

Reply:

Similar Artilces:

Excel on website
Hi, I have an Excel file which opens maximum at my desk, but it opens minimum when I view it on my company's intranet. I use FrontPage 03 and Excel 07. Please advice! Thanks Chi After moving the file to server and linked it to the page I got it! Thanks Chi "Chi" wrote: > Hi, > > I have an Excel file which opens maximum at my desk, but it opens minimum > when I view it on my company's intranet. I use FrontPage 03 and Excel 07. > > Please advice! > > Thanks > Chi > > > > > > Aft...

Sum
Hi, I just found this "feature" at Excel formulas today. Please, have a look at: http://danielgudang.multiply.com/journal/item/192 (in portuguese, but images show all) Let me explain: some cell C1 = sum (C2:C5) some cell D1 = sum (D2:D5) some cell E1 = sum (E2:E5) A1 = C1 - D1 - E1 B1 = C1 - (D1 + E1) A1 = B1 ??? Oh, not always! Sometimes A1 will be +0, sometimes -0. Really strange! It's a feature of any application that uses IEEE double precision floating point math (e.g., every commercial spreadsheet I know of). It's the result of having finite precision ...

Charitable Donations not showing up in Tax Category
When I run a tax report for 2005, only 4 of my charitable donations showed up. Yet when I go to that category (Charitable Donations) and run a category report for the year, I have about 10 listed. Why isn't the tax report picking them up? Thanks, Mark MS Money 2003 Deluxe Check the Tax Line association stuff in Category Details for each of your subcategories. "ATHiker95" <athiker95@yahoo.com> wrote in message news:1141861753.002183.218550@i39g2000cwa.googlegroups.com... > When I run a tax report for 2005, only 4 of my charitable donations > showed up. Yet when I ...

How do I stop 1 day tasks splitting over 2 days?
I am using Project 2003 and it has got an annoying habit of splitting most tasks with a duration of 1 day into 7 hours of work on one day and 1 hour of work the following day when you look at them within the Resource Usage view. This is mucking up my Gantt chart as the tasks effectively look as if they are 2 day tasks (although the duration cell definitely says 1 day). Any idea what is causing the problem and how do I fix it? Things to note: - The project calendar and resource calendars are definitely showing 8 hour working days (8-12 then 1-5) so that isn’t causing the probl...

Word 2003 stops working
Hi folks, Never had a problem with Word 2003 in the 3 years I've had this program. Suddenly, I have issues. A few minutes into opening a Word document, or upon attempted close of the document, I get a popup box with message "Microsoft Office Word has stopped working. A problem caused the problem to stop working correctly. Windows will close the program and notify you if a solution is available." When I close the popup, sometimes a new blank "document 1" opens up automatically. This happens with both Word docs and Outlook messages. Don'...

chart formatted for Weeks, not Days
I am trying to graph some data in Excel 2002 SP3. Column A contains dates (1 date every 7 days) and Columns B through Z the actual data. On my graph I wish to change to eliminate the extra spaces between data points because every day is displayed, not just the weekly dates entered. The only options in the Format Axis I can find are Days, Months, Years. Where is the Weekly option ? Any help is greatly appreciated. Thanks ! ...

Chart Legend #3
I have Line charts on various sheets. The charts are identical in size. There are 12 items graphed on each chart. However, the legend on each of the charts seems to be displaying different numbers of charted items. I'm not sure how to explain this clearly. On one chart's legend, it might show 12 items (three columns with four items each), which is correct. Another chart's legend may only show 2 columns totally only eight items (it should be 12). I even have one chart's legend showing only 4 items (as if it is only one column displaying). I can't figure out what...

Embedded Excel worksheet in PowerPoint
I'm working with an embedded excel worksheet in powerponit. The doc is sent to me and if I have to edit the worksheet, I find that some cells have missing characters once I open the worksheet to edit it. It appears that characters beyond some length (256?) are being truncated off. How do I resolve this so I don't have this problem again? Thanks, Barb Reinhardt This kind of problem may occur if the material was inserted into the embedded worksheet via copy/paste from an external sheet. A reliable approach is to open the embedded sheet first, and from that sheet do: File ...

Excel 2003 01-27-10
Hi all, hopefully you can help me. In cell B21 the user will always input an email address, i have created a button and now need the button to automatically email the email address in cell B21. I then need it to default and save to a specific location with the file name automatically generated from b12. Please help. :) ...

Purge data based on another Excel file???
I am attempting to purge data from a large list based on data in another document. I have the files I want to remaove in on file and the file I want to remove them from. There should be simple way to do this no? ...

A question regarding coordinates of points within a chart
Can anyone explain how x-y coordinates for points within a chart can be accessed via a mousemove event? I realize this will require quite a bit of coding, but I would like a little comment box to appear for any given point on an X-Y scatter I have. The data set consists of around 27000 points, and I would like the mousemove event to trigger a lookup into a table that contains a fairly lengthy descripion of each point. Wazooli Wazooli, Take a look at Jon Peltier's article on chart events . . . http://www.computorcompanion.com/LPMArticle.asp?ID=221 then, take a look at this post ...

Bubble Charts
Does anyone know if the bubble chart default shape of circle can be modified to other shapes (i.e. triangle, square)? The flexibility to present different shapes could be useful when presenting two series on the same chart. For example, one series could be the default circle, another a triangle. I have seen this capability in other applications with advanced charting capabilities. I am using Excel 2003. Regards, Joel Hi, Yes you can change the shape. To do so you need to use a custom marker. Create a shape using the autoshapes menu. Format the shape in terms of colour and border. Copy...

EXCEL 2007
I have a GIS application which uses .dbf files (not sure if they are actually Dbase files). When I need to append data (fields) to the files, I have a big problem in that excel 2007 no longer allows save as / export to .dbf files. If I try bring the data in MS Access and save as .dbf files, I have untold problems with the GIS application... The only way I have been successful with this is to find a user with an older version of excel, insert the data as database columns and then save as .dbf Any suggestions as to how I can get around this with out purchasing a converter? ...

in Excel: How do I change "selected cells" highlight color?
When I select cells in Excel the shading is so light (blue) that I can barely tell which cells are selected from those that are not. Can I change the background color of cells that are selected? Thanks. Assuming Excel 2007 this is a known problem and as yet no patch for it. I don't have Excel 2007 but I have read that playing with your Contrast can help some. Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 12:51:00 -0700, flameretired <flameretired@discussions.microsoft.com> wrote: >When I select cells in Excel the shading is so light (blue) that I can barely >tell whic...

email from excel workbook button does nothing
In my old version of excel(2003) as long as i had outlook open i could email directly from the worksheet. Now i have office 2007 with "windows mail" when i press the button in the "quick access" tool bar it does nothing. I have tried having widows mail open when I do it too but the only way i can send is by making file attachments. seems like the long way around. Is there something I am doing wrong? I have tried to read some of the previous posts and dont understand anything about codes ect. Please help, Mark hi Mark Is Windows Mail your default m...

Transfer Errors
Hello, I am seeing an issue where a store generates a Transfer Out and when the receiving store receives the corresponding Transfer In, extra items show up (seemingly random items with random quantities) there were never issued in the Transfer Out. Has anyone seen this or know why it happens or how to deal with it. It does not seem to occur when HQ initiates the transfer via the 330 worksheet, only when a store originates the Transfer Out. Thanks, Dave It kind of sounds like you have some item data that's out of sync between your stores. You could try reindexing all store datab...

Delete duplicate rows from a list in Excel
Hi, Below are instructions on how to "delete duplicate rows from a list in Excel". I learned about this tip from the Microsoft Office Assistant website. However, each time I try step 4, my list is not filtered and no records are hidden. Is there a secret I am missing to make this work? Thanks for your help! -Greg http://office.microsoft.com/en-us/assistance/HA010346261033.aspx Applies to Microsoft Office Excel 2003 Microsoft Excel 2002 A duplicate row (also called a record) in a list is one where all values in the row are an exact match of all the values in another row. To delet...

How to tell Excel to insert cells and shift down from Access
Hi all, I have Access 2003. I am trying to tell Excel to insert cells and shift cells down from Access, with this line of code: oWksh.Cells.Insert Shift:=xlDown But Access does not like that line. It gave me run-time error 1004. I know if has to do with the part Shift:=xlDown Can you suggestion what I can do? Thank you in advance, Ben "Ben" <Ben@NoSpam.com> wrote in message news:eSZuzcDpKHA.1892@TK2MSFTNGP02.phx.gbl... > Hi all, > > I have Access 2003. I am trying to tell Excel to insert cells and shift > cells down from Access,...

Text Wrap in Excel 2002
I have been having difficultly wrapping text. I merge several cells and wrap text sucessfully. However, if I go into one of the cells and add a couple of sentences and enter, my text that was wrapped perfectly is simply a string of #########'s and I can't view the text correctly by changing the row height or reformatting (even though it is all still there - as I can see in the edit box - when my cursor is on the text box). Any suggestions? Try formatting the cell as General. bdean wrote: > > I have been having difficultly wrapping text. I merge > several cells an...

Excel Version When Posting Please State Your Excel Version!!!
On Jan 8, 6:58=A0pm, "Tyro" <T...@hotmail.com> wrote: > Subject: Excel Version When Posting Please State Your > Excel Version!!! And Please Include Your Questions and Comments In the Body of Your Posting!!! Not just in the subject line, even if it simply duplicates the subject line. Some news readers truncate the subject line. Some news servers do not permit you to reply to articles with empty bodies. Some news servers seem to reject such articles when they come in from the network, or perhaps the originating news server does not push them into the network. That ...

EXCEL Cell Formatting: Custom or Conditional
At work I have Excel 2002 and I have some cells that I import data in from the mainframe. I have a table where there is a column for GENDER (MALE or FEMALE) that I would like to see shown as "Male" or "Female" (mixed case). Is there a way to change all upper case to mixed case using either CUSTOM formatting or CONDITIONAL formatting? I would prefer not using a macro if there is something simpler. I know that =PROPER() produces the correct result, but I don't see how I can use this unless I'm referencing another cell. I would like to be able to just change what fa...

Excel Formulas
I have a spreadsheet showing whether customers have paid their debts or not. Each row represents a customer and details of the debt and the last cell in the row states whether the debt is "PAID" OR "UNPAID". Where the word "PAID" appears in a cell, I want to write a formula that will move that whole row to a different location on my sheet. I eventually want to record this action on a MACRO, so that every time I run a MACRO on my accounts spreadsheet it will take the updated information of customers marked "paid" and put in a seperate spreadsheet. Ple...

how can I change the a,b,c, column headers in excel to names
I've tried and can't figure out how to change the column header from a,b,c, etc. to names for each column. Any tips are appreciated You can only show A,B,C...,IV or numbers: 1,2,3,...,256 But you could put your names in Row 1 and then select A1, then select A2 and click on Window|Freeze panes. espray wrote: > > I've tried and can't figure out how to change the column header from a,b,c, > etc. to names for each column. Any tips are appreciated -- Dave Peterson ...

Show linked cell alone somwhere on the desktop
I have DDE linked data in excell. After the all calculations I have result which is one cell. I need to see this "live" cell somwhere on the screen all the time (Excell can be open in background) and I want to see this number only or as less frame as possible - what is my options? Simply when I'm working with other software there is no way to squeeze in all Excell even if I have multiple monitors (: Thks. It's still me - Simplifying my question. Is there any way to bring Excel spreadsheet out of main Excel frame - in Office 2007? "GPS" wrote: > I have D...

Trendline erases chart name
When I add a trendline, the chart name gets changed to "Chart Title." The name can be seen in the Chart Objects drop box, if I scroll down enough. When I add the tendline, I'm leaving the Chart Title box marked as automatic, but it still replaces the name to Chart Title. (The name on my charts just comes from the data field that is above numerical data when I create the chart.) I have a lot of charts to go through, >100, so any help in retaining the name without having to retype it would be greatly appreciated. Thanks! I cannot think how this can happen. Email me the fi...