Creating Graphs in Excel (1 Viewer)

[Mahendra]

Dear All,

Am trying to create a graph in excel with my values. The categorization of y-axis values are done according to my views and am unable to categorize the x-axis values.

I need the x-axis categorization as 0,10,20,30,40,50,60.

I tried by viewing many articles and videos but am not enough luck to made my day. Am seeking for any positive views on my sheet.

The x-axis values are not clear in my graphs. I need it according to my categories above.

Please help me out. Am attaching my excel sheet.

Thanks

 

[sneuberg]

I am not an expert on Excel but I played with yours and couldn't get anywhere with what you had, so I just selected the data for the first battery and click on Recommended Charts under the INSERT tab. It recommend a scatter chart. It seems to be scaled about the way you would like. So maybe choosing a different style of chart might help.

 

[yupstrips01]

Basic Graphing in Excel

Table of Contents

Entering and Formatting the Data in Excel
Creating the Initial Scatter Plot
Creating a Scatter Plot of Titration Data
Changing the Scatter Plot to a Line Graph:banghead: