If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
No Range on data
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. |
#2
|
|||
|
|||
No Range on data
We missed the part of your message where you told us what type of chart you
are using. -- David Biddulph "Chris Ritchey" Chris wrote in message ... 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. |
#3
|
|||
|
|||
No Range on data
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, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chris Ritchey" Chris wrote in message ... 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. |
#4
|
|||
|
|||
No Range on data
I tried changing the series data like you said. I entered:
=SERIES(,{710004,7170002},{12.5,14.29},1) Just trying to get two part numbers with two values. When I graph this, the horizontal axis is still a range (0, 20000, 40000, 60000, 80000). I just want the horizontal axis to have only the numbers I put, and not a range. Any help would be greatly appreciated. Thanks, Chris Ritchey "Jon Peltier" wrote: 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, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chris Ritchey" Chris wrote in message ... 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. |
#5
|
|||
|
|||
No Range on data
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chris Ritchey" wrote in message ... I tried changing the series data like you said. I entered: =SERIES(,{710004,7170002},{12.5,14.29},1) Just trying to get two part numbers with two values. When I graph this, the horizontal axis is still a range (0, 20000, 40000, 60000, 80000). I just want the horizontal axis to have only the numbers I put, and not a range. Any help would be greatly appreciated. Thanks, Chris Ritchey "Jon Peltier" wrote: 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, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Chris Ritchey" Chris wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|