No Range on data

  • Thread starter Thread starter Chris Ritchey
  • Start date Start date
C

Chris Ritchey

Im trying to create a chart that uses just the data that I enter, not a
range. For example, I have part numbers like 717000, 717003, 717009. I
don't want the entire range, I just want those three part numbers. I never
had this problem with older versions of excel, but 2007 I just can't seem to
figure it out. Any help would be greatly appreciated.
 
You could edit your series formula so it looks like this:

=SERIES("Title",{"A","B","C","D"},{1,2,3,4},1)

Or you could do it bit by bit, entering ={"A","B","C","D"} in the
'Horizontal (Category) Axis Labels' Edit dialog, and ="Title" and ={1,2,3,4}
in the 'Legend Entry (Series)' dialog. It's more complicated and less
intuitive in the Excel 2007 dialogs, isn't it?

- Jon
 
If you want to use the part numbers as labels, you must enter them as
labels, and you cannot use an XY chart. Use a line chart instead, and format
the series formula like so, with double quotes around each label:

=SERIES(,{"710004","7170002"},{12.5,14.29},1)

- Jon
 
Back
Top