Forum

Notifications
Clear all

Creating a graph with x and y axis ranges and data points

2 Posts
2 Users
0 Reactions
51 Views
(@agalmethu35)
Posts: 1
New Member
Topic starter
 

I am trying to make a graph that has a range from 0-800 in 100 increments on the y axis and 0 to 6.5 on the x axis in .5 increments. They aren’t the data points but I need to be able to insert one value for the x axis and one for the y axis and see what the line looks like. For example, 103 and 2.5. I am not sure how to make the graph without it taking the 0-800 and 0-6.5 as the actual data points. Thank you!

 
Posted : 22/11/2020 11:56 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Agal,

I presume you want a scatter chart?

Enter your data and create the chart, then select an axis and right-click -> Format Axis.

Then set the min and max for the axis and set the major units

Here's a sample Excel file with chart.

Regards.

Phil

format axis menu

format axis

 
Posted : 22/11/2020 10:38 pm
Share: