Problem with charting Net income vs Year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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
 
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
 
Back
Top