Excel to Graph

Plot XLSX data and its rate of change in separate charts. Select a sheet, header, X column and multiple Y series. Files stay in your browser.

Your files are processed in your browser and never uploaded.

Drop an XLSX file here

Choose an XLSX file

XLSX · up to 10 MB · processed in your browser

How to use

  1. Choose an XLSX workbook. The file is processed locally in your browser, not uploaded.
  2. Select a sheet and its header, then choose the time or X column and one or more Y series.
  3. Review the original values and the first derivative; they are combined in one dual-axis chart by default, and can be split into two charts. Check omitted points, the time intervals and the units before interpreting the result.

Features

Choose the data to compare
Select the relevant sheet, header, X column and multiple Y columns to see the series against a shared horizontal axis.
Data and rate in one chart
Original values are drawn as solid lines on the left axis and their rates of change as dashed lines on the right axis, combined in one chart by default; clear the merge option to split them. The rate is estimated using numerical differences, not a quadratic fit; optional smoothing over 3–15 neighboring samples can reduce noise.
Local processing
Your XLSX workbook is read in your browser and is not uploaded to a server.
Read a single time point
Point at or tap a time to read each selected series at that sample, or open the table below the chart to inspect the plotted values.

Preparing a workbook

Use an XLSX workbook with the observations you want to compare on the same sheet. Choose the header that identifies the columns, then select the time or other X column and the Y columns containing the measurements. For example, one column might contain observation times and two others might contain temperatures from different sensors. Selecting both measurement columns lets you compare them against the same X values without mixing the original measurements with their rates of change.

Before interpreting the charts, inspect the source sheet. Make sure the selected header belongs to the data, the X values represent the intended time or quantity, and each Y column has the expected measurements. Duplicate timestamps or X values and invalid points are omitted; missing or unusable observations can leave a less complete picture than the original table. Check the workbook when a chart contains fewer points than expected.

Reading the charts

The chart shows the selected values against X. Solid lines are the original measurements on the left axis, useful for seeing whether a sensor reading rises or falls over the recorded period. Dashed lines are estimates of the first derivative on the right axis: how quickly each value changes as X changes. A positive rate indicates an increase, while a negative rate indicates a decrease. A rate near zero suggests little change over the observations used for that estimate. The two are combined in one dual-axis chart by default; clear the merge option to show them as two separate charts.

The vertical axes use different units, so a rate is not directly comparable to an original measurement. Do not compare the heights of a solid and a dashed line, and read exact values from the hover readout or the table below the chart.

The rates are calculated using numerical differences between data points, not by fitting a quadratic curve. They approximate change in the observed data; they are not exact derivatives of an underlying process. Nonuniform timestamps can be used because the actual X differences matter. A change of ten units over two hours is a different rate from the same change over ten hours. Duplicate X values do not provide a usable interval and are omitted, as are invalid points.

The rates also offer smoothing. Selecting 3, 5, 9 or 15 points shows, at each position, the centered average of the rates at that many neighboring samples. A wider window gives a smoother curve but can weaken brief real changes. Smoothing applies only to the rate curves; the original values are always shown unsmoothed, and smoothing does not restore missing or omitted points.

Check units and uncertainty

A derivative’s unit is the Y unit divided by the X unit. For example, a temperature measured in degrees against time measured in hours gives a rate in degrees per hour. Verify what the workbook’s timestamps and measurements mean before comparing rates or reporting them. If series use different measurement units, their values and rates are not directly comparable without accounting for those units.

Small changes in measurements can become conspicuous when numerical differences are taken, particularly over short intervals. Noise, rounding, gaps and omitted points can affect the estimated rate, so investigate unexpected spikes in the source data rather than assuming they describe a real event. The charts support exploration; important conclusions should be checked against the original observations and the context in which they were collected.

Frequently asked questions

Which spreadsheet files can I use?

The tool accepts XLSX workbooks. Select the sheet containing the data you want to plot, along with its header and columns.

What does the derivative chart show?

It shows an approximate first derivative, or rate of change, for the selected Y series with respect to X. It is calculated from numerical differences rather than a quadratic fit.

How do I read the two vertical axes?

Solid lines use the left axis and show the original measurements. Dashed lines use the right axis and show rates of change in Y units per X unit. The scales are independent, so do not compare the heights of a solid and a dashed line; hover over a point or open the table for exact values.

Can the time intervals be uneven?

Yes. The calculation uses the differences in X, so intervals need not be equally spaced. Check the timestamps and their units when interpreting the rates.

What happens to duplicate or invalid points?

Duplicate timestamps or X values and invalid points are omitted. Review your source data because omitted points can change which observations are available for the estimate.

Why does the rate chart look noisy?

Differences can amplify measurement noise, especially when X values are close together. The derivative is an approximation, not proof that every sharp change is real. If you only need the trend, set rate smoothing to 3–15 points to average nearby rates; smoothing affects only the rate curves, not the original values.

Is my workbook uploaded?

No. The workbook is processed locally in your browser and is not uploaded to a server.

Related tools