Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When entering data into a range of cells, select the entire range. | Excel Discussion (Misc queries) | |||
How do I link data from a horizontal range to a vertical range? | Excel Worksheet Functions | |||
Show Data In Range not appearing in Separate Range | Excel Discussion (Misc queries) | |||
How do I change a range name back to the underlying data range? | Excel Worksheet Functions | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel |