Displaying Multiple Excel files, Not plotting zero values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello,

I have two questions:

1) How ccan I display more than one Excel workbook in different window? When
I open more than one Excel workbook, I want to display them side by side to
make some comparisons. When I open one other closes. Is there a way to open
many Excel windows?

2) I have a data set with lots of zero values. I use scatter plot. I want to
only display non-zero values. How can I do it?

Thank you.

Athena


.

Relevant Pages

  • Importing data from excel into word
    ... I have a vast amount of data in an excel workbook, and need to export it to ... but it needs reformatting for display and simplicity purposes. ...
    (microsoft.public.word.docmanagement)
  • VBA coding to retrieve data from Access to Excel :S
    ... program to bring data from a database where the program using the SETUP ... sheet from the excel workbook as its critaria and then populates the ... DATA sheet. ... I then can use the DATA sheet to display data in the ...
    (microsoft.public.excel)
  • Format display in DBGrid cell? (D2007 and Vista)
    ... I display data from an Excel workbook using TADOConnection, TADOQuery, TDatasource and TDBGrid. ... My problem is that one of the columns in the workbook is formatted as Currency with two decimals, but in the DBGrid both the currency prefix and any trailing decimals equal to zero are suppressed. ... I don't care about the currency prefix in this display, but I should very much like to have both decimals shown whether or not they are zero. ... In that program I already used TADODataset (instead of TADOQuery) and was told how to control the DBGrid display using the fielddef properties in TADODataset. ...
    (borland.public.delphi.database.ado)
  • memory low error when inserting object
    ... I am trying to an embed an excel workbook into a power point presentation ... My problem is that when I target the object (I want to display as an icon) ... and try to insert it I get an out of memory problem. ...
    (microsoft.public.powerpoint)
  • Re: PDA as "X terminal" [lengthy]
    ... moves that out to the physical display (via VNC or ... finished filling in the window *before* updating the ... Each cell is a (character, ... immediately above the "write pixel" level (note that it doesn't ...
    (comp.arch.embedded)