Create continuous density curve from pivot table?

[OldManExcellor]

I have created this table with the pivot table function. The first column is supposed to be the x-axis. The second and third columns are supposed to be values for two density curves in a graph.

0,88	0,007990241	0,007014028
0,89	0,011448944	0,011022044
0,91	0,020942602	0,02004008
0,93	0,05689206	        0,052104208
0,94	0,084130296	0,077154309
0,96	0,108859757	0,110220441
0,98	0,132474609	0,129258517
1	0,140641581	0,150300601
1,02	0,163591684	0,152304609
1,04	0,098615796	0,106212425
1,06	0,074624989	0,076152305
1,09	0,07726832	        0,080160321
1,11	0,013411459	0,017034068
1,14	0,006362309	0,007014028
1,16	0,002711613	0,003006012
1,19	3,37395E-05	0,001002004

My question is, how can I make the x-axis become "smooth and continuous"? As it is now there is as much space between 0,88 and 0,89 (first and second data points) as there is between 0,89 and 0,91 (second and third data points). I want the space to be the same between 0,88 0,89 0,90 0,91...

What is a good way to achieve this?

 

[sijpie]

What you need is to have your chart set up as a "X-Y Scatter Diagram". That means a normal x-y graph in Microsoft speak.

If you use a line diagram, then Excel will take each item from the x-axis as being a text label rather than a value. So it could read 'camel' rather than 0.88 for all Excel cares....


Does this help you at all?

 

[OldManExcellor]

Yes, that worked! Thank you very much!

An additional question. Is it possible to have an "x y scatter" visualized as bars instead of lines and dots?

 

[sijpie]

Peltier is the man who knows everything yo can do with charts in Excel. He doesn't mention bars in a x-y scatter, but he does mention fill. See this link:
http://peltiertech.com/Excel/Charts/XYAreaChart.html