1 / 18

Step-by-Step Guide to Graphing LIBS Spectral Data in Excel

This guide walks you through the process of graphing LIBS spectral data using Excel. Beginning with opening a sample CSV file, you will learn how to identify the relevant wavelength and intensity columns, select the data, and insert an XY scatter chart. Follow detailed steps to format the chart, adjust axis values, and add titles. Finally, ensure your graph is saved correctly to avoid losing your work. By the end of this tutorial, you will effectively visualize LIBS data in Excel.

sheila
Télécharger la présentation

Step-by-Step Guide to Graphing LIBS Spectral Data in Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Ver1.2

  2. Graphing LIBS spectral data with Excel

  3. STEP 1 Open the LIBS-Data-Sample1.csv file

  4. STEP 2 Find the Wavelength and Intensity columns

  5. STEP 3 : Select data Highlight both columns Tip: Select the wavelength and intensity cells. With both still selected, click Ctrl-Shift-Down. The columns will be highlighted top to bottom. Then scroll back to the top.

  6. STEP 4 : Chart Select Insert > Recommended Charts

  7. STEP 5: Select chart type Select: XY (Scatter) with lines

  8. STEP 7 Your chart should look something like this:

  9. STEP 8 : Resize chart Select the chart and then Format Chart Area …

  10. STEP 9: Resize chart so you can see it easily.We use: Height = 17 cm, Width = 29 cm

  11. STEP 10: Format X axis Select the X axis and then Format Axis …

  12. STEP 11: Set X axis values Change the Minand Max axis bounds and the Majorand Minor units as shown:

  13. STEP 12: Format Y axis Select the Y axis and then Format Axis …

  14. STEP 13: Set Y axis values Set the Minimum axis bounds to 0.All other values are left set to ‘Auto’.

  15. STEP 14: Add titles Add a title for your chart and label each axis

  16. STEP 15: Your finished chart should look like this.

  17. STEP 16: Save your chart Be sure to save your chart as an Excel format (.xlxs or .xls) not a .csv or you will loose your chart!

  18. End

More Related