Problem with charting Net income vs Year

[Hunter]

Im having some problems with my Excel chart. It will not plot Net Income vs Year. It keeps trying to treat Year as a different data series. It will work if I use text i.e. a1990, a1991, etc. but it refuses to use 1990, 1991... Any Ideas???

 

[Jerry W. Lewis]

Use an "XY (Scatter)" chart, instead of a "Line" chart.

Jerry

 

[Jon Peltier]

Delete the contents of the cell at the top of the Year data. Excel will
use columns with a header cell for Y and the first column as X if it
lacks this header.

- Jon

 

[Tushar Mehta]

Because of a silly quirk, for some chart types XL treats any column
with a header as a seperate series. Your options: (1) delete the Year
header and then plot the series, (2) in step 2 of the Chart Wizard,
click on the Series tab, copy the 'values' entry of the first series
into the 'category' field, then delete the first series.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions