On Ms Excel I need to create a graph starting from: X=0 Y=0 instead of: X=1 Y=0.?

Question

On Ms Excel I need to create a graph starting from: X=0 Y=0 instead of: X=1 Y=0.
I need to create a graph on Ms Excel starting from: X=0 Y=0 (startinf from the absolute corner and progressing, f.e.: X-Y: 0-0 > 1-4 > 3-1 etc.).
but the current, or default I believe settings on Office 2003, generates every graph starting from X=1, Y=0. I believe it needs me to change something on "Format Object" or on "Format Data Series", "Options", "Axis", or something like that, but I don't know what.
Many-many thanks!

Answer 1

you are trying to plot a column vs the row number?



make a column of X values and a column of Y values, and plot the Y column vs the X column



cheers

Answer 2

Go to excel enter your data onto the spread sheet highlight it then go to the icons at the top click on the chart wizard then it'll give you a list of eg block columns, pie charts, graphs etc etc click on the one you want then just fill out the info and Excel will compile the graph etc. Hope that helps!!!

Answer 3

enter your documents into the spreadsheet in a table format with column headers, row headers and documents in the middle. 2.go with the cells that contain the help which you quite % to look in the bar graph. in case you % the column labels and the row labels to look in the graph, make certain that those are chosen additionally. 3.Press the F11 button on your keyboard. this could create your a graph on a “chart sheet.” (A chart sheet is quite a spreadsheet internet site interior of a workbook this is carefully committed to showing your graph.) 4.on the Chart toolbar, which looks after your chart is created, click on the arrow next to the Chart sort button and click on the Bar Chart button. 5.finished.