No Range on data

[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.

 

[David Biddulph]

We missed the part of your message where you told us what type of chart you
are using.

 

[Jon Peltier]

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

 

[Jon Peltier]

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