Why selecting two columns (x and y) for plotting produces two graphs?

Jamal NUMAN · #1 01-21-2012, 12:42 AM

Why selecting two columns (x and y) for plotting produces two graphs?

I’m wondering why the default in the Excel is to plot two graphs when two columns are selected.

For example, to plot x versus y as shown in screenshot 1:

1. I selected the two columns (x and y)

2. I selected inset >l ine> stacked line with markers (screenshot 2)

3. I got the graph shown in screenshot 3

My question is:

- Why I got two graphs (the red and the blue one)? I expected to get just one graph

- Whey all the values of the first column do not exist in the output graph?

- Has this behavior been in the Excel 2003?

What I wanted is:

When I select two columns to plot, then I expect to have only one graph and to have all the values of the columns in the two axis (the axis must extend to include the maximum value in each column)

Thank you in advance,

Regards

Jamal

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Graphs	timeitniear	Excel	1	09-22-2011 02:26 AM
Graphs: how to stop displaying a value	thorgal67	Excel	2	12-17-2010 07:59 AM
Selecting specific text out of a series of columns	speedycorn1	Word	3	11-01-2010 02:58 PM
How to compare 2 columns with other two columns in EXECL 2007?	Learner7	Excel	5	06-12-2010 09:54 AM
Plotting LARGE WALL CHARTS	Butch Jackman	Excel	0	05-25-2006 07:06 AM