Displaying Multiple Excel files, Not plotting zero values

A

Athena

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
 
D

Debra Dalgleish

1) With both workbooks open, choose Window>Arrange
Select an Arrange option, click OK

2) Create a chart from all the data.
Apply an AutoFilter to the list (Custom, does not equal zero), and the
chart will show only the non-zero values.
 
Top