Forum Home
Press F1
Thread ID: 60718	2005-08-10 22:09:00	Excel Chart Query	d.murray (276)	Press F1

Post ID	Timestamp	Content	User
380176	2005-08-10 22:09:00	Its some time now since I last had to create a chart in Excel, must have lost the touch . I'm trying to create a simple chart of time-temperature for a kiln firing in Excel 97 . Creating the chart I seem to get temperature as the y axis and the two data series plotted with the x axis as the number of data points rather than the time (hours) . Can anyone let me know how to get a simple time - x axis and temperature - y axis graph . I feel daft to be asking such a simple question but I can't figure it out Thanks	d.murray (276)
380177	2005-08-11 07:55:00	Hard to explain but ill give it a go... Make a column with time (left) and a column with temp (right) next to each other. Highlight the 2 columns and select chart wizard. Select X-Y scatter as the chart type, and the appropriate format (smoothed lines, markers etc.) Next, check that the series is selected as columns, and that in the "series" tab the x-values and y-values are for the correct columns. Add labels, title etc. and your done! Hope this helps, Roddy	roddy_boy (4115)
380178	2005-08-11 22:13:00	Thanks - that worked well. Dont know why I coudn't get it in the first place, must have locked in brain fade. Now all I have to do is find out why the kiln is not reaching the required temperature which is why I wanted to plot the firing in the first place. Thanks D	d.murray (276)
380179	2005-08-11 22:22:00	electric or gas fired? sarel	sarel (2490)
380180	2005-08-12 00:02:00	electric or gas fired? sarel 5cuft Cobcraft electric. Took 17hrs to get to 920 degrees inspite of increasing the ramp rate from 50 to, in the last few hours, 200. The kiln has been converted from 3 phase to 2 phase - I'm not sure whether it's the rewiring or the controller - should get there by a process of elimination. Eventually D	d.murray (276)
380181	2005-08-12 00:35:00	Good luck - I think you will find that it is the controller because a break in the wiring inside the kiln is quite noticable. I had the luck of having an Eelctrician friend that could test everything. With one of our kilns it ended up replacing the wiring inside due to old age, but with all our other kilns the problems usually turned out to be with the controller. sarel	sarel (2490)
380182	2005-08-12 01:20:00	Thanks - I've borrowed another controller to try but since my last post I've found that the electrician that rewired the elements from 3 phase to 2 phase had changed 3 banks of 3 elements into 2 banks of 5 and 4, I gather that it should have been wired as 2 banks on one phase and 1 bank on the other - thus the kiln should not be pulling enough power especuially at the higher temps. So I'll change that first and then try the alternative controller. D	d.murray (276)
1