0

First generated graph

Second corrected values

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?

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.