I feel stupid for asking but...
When making a graph, i have 2 columns of numbers. I want 1 column to be represented by the x-axis, and 1 by the y-axis. I highlight both, press chart wizard and then select line graph.
however it comes up with 1 column in the y-axis, and the x-axis is just the numbers 1, 2, 3, 4, 5 etc. The second column is then put in as a second series. How do I change this?
I tried putting the 'category (x)-axis labels' as the second column but the scale isn't right, as it puts the values as categories.
please help
2007-03-14 00:13:48 · 3 answers · asked by Anonymous in Computers & Internet ➔ Software
Instead of doing a line graph, select an xy scatter plot. Then put the cells you want on the y axis as value y axis and the cells you want on the x axis as value x axis.
2007-03-16 05:10:03 · answer #1 · answered by Paul 1 · 0⤊ 0⤋
1 column cannot be represented on the x-axis and the other cannot be represented on the y-axis, that's not how it works.
The intersection of the Y axis and the X axis represent your data point. If you want two line graphs representing each column, set up the data in two rows. Each row should have a label and each column should also have a label. For example, column A2 would read 'Car', A3 has 'Bike'. B1 has Jan, C2 Feb. B2:C3 have your values. Click the chart wizard and it will create the chart.
2007-03-15 01:34:26 · answer #2 · answered by icepero 3 · 0⤊ 0⤋
well.. i am not sure what exactly ur asking for.. did u checkout this website www.excelgoodies.com , try them.. there would be some excel consultants online to help you on that..
2007-03-14 14:39:50 · answer #3 · answered by sam e 2 · 0⤊ 1⤋