2D XY Line Chart, plotting a % quantity passed against specific sieve sizes

[siash69]

Hi, I have created a simple XY Line chart to chart the relationship of aggregates by percentage passing (Yaxis) specific sieve sizes (Xaxis), insted of showing a range of sizes from 0-10, is there any way I can show my specific sieve sizes (10, 5, 2.36, 1.18, 0.6, 0.3, 0.5) instead of just a range of 0-10 with specific interval markers. Im using Excel from my Office 365 package.

Thanks

Si

 

[Jon Peltier]

Uh, you can't use the specific sieve size values for your X values?

Note that you may want to make an XY scatter chart, the option with markers and lines, rather than a line chart, if you want the X axis to display meaningful numerical values. (You mentioned an XY Line chart, but that doesn't exist. You're confusing a Line chart with an XY Scatter chart.)

 

[siash69]

Ok thats great I have plotted my data as an XY scatter chart, looked in axis options to try and see where can set specific values for my Xaxis but can't work out how to do it, could you please suggest how I can do it?

Thanks

Si

 

[Jon Peltier]

In an XY Scatter plot, you can set minimum and maximum axis values, plus the spacing of major (labeled) and minor (unlabeled) tick marks.

If you want to display a tick mark and label for each of those values, then you do want a Line chart.

Put the data into two columns, with the sieve sizes in the first column and % passing in the second. Put a label in the cell above the % passing values, and keep the cell atop the sieve sizes blank. The blank cell tells Excel to use the first column as X labels.

 

[siash69]

Thanks, just what I needed, much appreciated.