| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Long time user,can't create a chart-help!
Using office since 1995 and creating superb charts. Just installed office 07
in a new computer and I am stuck. In the past for all additions I would enter ,for example =A1:A500,B1:B500, Choose my chart style and a chart would be generated after filling in the various dialogue boxes. I do the same now and I just get error messages. Can I set-up Excel to behave in the manner that I am accustomed to. Thanks for your help |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Long time user,can't create a chart-help!
My 2007 machine is in the other room, so I can't test right now. Try
referencing the address with the parent worksheet's name: =Sheet1!A1:A500,Sheet1!B1:B500 If there are spaces in the sheet name, surround the name with single quotes: ='Sheet 1'!A1:A500,'Sheet 1'!B1:B500 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ChasX" wrote in message ... Using office since 1995 and creating superb charts. Just installed office 07 in a new computer and I am stuck. In the past for all additions I would enter ,for example =A1:A500,B1:B500, Choose my chart style and a chart would be generated after filling in the various dialogue boxes. I do the same now and I just get error messages. Can I set-up Excel to behave in the manner that I am accustomed to. Thanks for your help |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Long time user,can't create a chart-help!
"Jon Peltier" wrote: My 2007 machine is in the other room, so I can't test right now. Try referencing the address with the parent worksheet's name: =Sheet1!A1:A500,Sheet1!B1:B500 If there are spaces in the sheet name, surround the name with single quotes: ='Sheet 1'!A1:A500,'Sheet 1'!B1:B500 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "ChasX" wrote in message ... Using office since 1995 and creating superb charts. Just installed office 07 in a new computer and I am stuck. In the past for all additions I would enter ,for example =A1:A500,B1:B500, Choose my chart style and a chart would be generated after filling in the various dialogue boxes. I do the same now and I just get error messages. Can I set-up Excel to behave in the manner that I am accustomed to. Thanks for your help I understand. Thank you very much for your rapid response! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clearing cells takes long, long time | Excel Discussion (Misc queries) | |||
| How to create a time study chart | Charts and Charting in Excel | |||
| How do i create a pie chart that shows % of time on tasks? | Charts and Charting in Excel | |||
| Create dictionary of terms, create first time user site | New Users to Excel | |||
| How do i create a user defined chart in Powerpoint or excel? | Charts and Charting in Excel | |||
Linear Mode
