FG

Map one column to x axis second to y axis in excel chart

Fresh3 days ago
Mar 15, 2026692615 views
Confidence Score0%
0%

Problem

I'm struggling while trying to plot simple data into a simple chart in Excel (2010 beta). My data is a very simple one: etc. In the chart, I want year to be the X axis and the value to be the Y axis, and have a single line mapping the change in value over years. When I select my data, Excel wants t…

Error Output

Value    Year  
-----    ----
1        1900
5        1902
3        1912

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Map one column to x axis second to y axis in excel chart

Low Risk

For MS Excel 2010, I struggled with same issue i.e. instead of X-Y chart it was considering two columns as two data series. The catch to resolve it is after you select cells including all data points and column headers, you should insert -> chart ->…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment