Excel Graph

lavakugan

New Member
Joined
Sep 3, 2014
Messages
1
Hi,
I have a graph with x and y values. I have more than 10,000 points.

For an easy example,
Say
x y
1 2
2 6
3 7
4 9
5 11

I like to have a graph with x and y values but eliminate one coordinate. For example, for one condition, I like to remove the coordinate (3, 7). The graph should break in between x values 2 and 4 . With the other condition, I like to remove the coordinate (4,9). What type of condition I should provide?

Thanks.

Kugan
 

Some videos you may like

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

Watch MrExcel Video

Forum statistics

Threads
1,108,984
Messages
5,526,062
Members
409,684
Latest member
Nazmul00

This Week's Hot Topics

Top