I'm trying to generate a graph using the values listed in the data tables above the graph; when first generated the scale of the x-axis is wrong and when corrected, the plotted points disappear. How can I stop this from happening?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
The first data point is a text cell with the value
(torr). That causes Excel to use categorical data on the X axis instead of the numerical values. It numbers the data points from 1 to 10. If you move the X axis to show categories starting from 400, there is no data there.
Change the data source of the X and Y to start from the first row with numbers and the chart will plot correctly.