Displaying Multiple Excel files, Not plotting zero values

  • Thread starter Thread starter Athena
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display zero in the cells with Excel 2013 5
Displaying zeros in cells 2
Formula to find first non-zero value in series? 5
Plotting with 3 columns data (X,Y and Values) 1
Chart (scatter plot): values on X-axis. 1
How do I eliminate empty cells from plotting on chart 1
problem with scatter plot an the millennium 2
Excel MS Excel in Win 10 3

Back
Top