| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
3-D Scatter (XYZ) Chart in Office 2003?
Hello, Does anyone have a solution for creating a 3-d scatter diagram in
Excel 2003? TIA -- Bob |
|
#2
|
|||
|
|||
|
Hi,
Nothing built in to do 3-d scatters. For work arounds have a look at Fernando Cinquegrani's example, http://www.prodomosua.it/ppage02.html or my own http://www.andypope.info/charts/3drotate.htm Cheers Andy B_S_D wrote: Hello, Does anyone have a solution for creating a 3-d scatter diagram in Excel 2003? TIA -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#3
|
|||
|
|||
|
Thanks - great resources!
|
|
#4
|
|||
|
|||
|
Andy, Thanks for the tip ... Fernando's four quadrant scatter diagram is
exactly what I'm looking for. Unfortunatly, I don't speak the languange! Can you by any chance explain how to use the add-in? Thanks! "Andy Pope" wrote: Hi, Nothing built in to do 3-d scatters. For work arounds have a look at Fernando Cinquegrani's example, http://www.prodomosua.it/ppage02.html or my own http://www.andypope.info/charts/3drotate.htm Cheers Andy B_S_D wrote: Hello, Does anyone have a solution for creating a 3-d scatter diagram in Excel 2003? TIA -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#5
|
|||
|
|||
|
Hi,
Are you are referring to Fernando's 3d.xls sample file. Unfortunately this is protected. You can plot up to 200 points by simply placing your xyz values in the available cells. If that's not the example you are referring to post back. Cheers Andy abrusey wrote: Andy, Thanks for the tip ... Fernando's four quadrant scatter diagram is exactly what I'm looking for. Unfortunatly, I don't speak the languange! Can you by any chance explain how to use the add-in? Thanks! "Andy Pope" wrote: Hi, Nothing built in to do 3-d scatters. For work arounds have a look at Fernando Cinquegrani's example, http://www.prodomosua.it/ppage02.html or my own http://www.andypope.info/charts/3drotate.htm Cheers Andy B_S_D wrote: Hello, Does anyone have a solution for creating a 3-d scatter diagram in Excel 2003? TIA -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#6
|
|||
|
|||
|
I've downloaded the "Cluster.exe" add-in. He's provided the password to use
the it, but I'm prompted to enter axis criteria and I can't understand the language. I'll try placing my data in his spreadsheet and see if I can work it that way. "Andy Pope" wrote: Hi, Are you are referring to Fernando's 3d.xls sample file. Unfortunately this is protected. You can plot up to 200 points by simply placing your xyz values in the available cells. If that's not the example you are referring to post back. Cheers Andy abrusey wrote: Andy, Thanks for the tip ... Fernando's four quadrant scatter diagram is exactly what I'm looking for. Unfortunatly, I don't speak the languange! Can you by any chance explain how to use the add-in? Thanks! "Andy Pope" wrote: Hi, Nothing built in to do 3-d scatters. For work arounds have a look at Fernando Cinquegrani's example, http://www.prodomosua.it/ppage02.html or my own http://www.andypope.info/charts/3drotate.htm Cheers Andy B_S_D wrote: Hello, Does anyone have a solution for creating a 3-d scatter diagram in Excel 2003? TIA -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
|
#7
|
|||
|
|||
|
Sorry my Italian is non existent. Have you tried using the Google
language tools to get a translation http://www.google.co.uk/language_tools?hl=en abrusey wrote: I've downloaded the "Cluster.exe" add-in. He's provided the password to use the it, but I'm prompted to enter axis criteria and I can't understand the language. I'll try placing my data in his spreadsheet and see if I can work it that way. "Andy Pope" wrote: Hi, Are you are referring to Fernando's 3d.xls sample file. Unfortunately this is protected. You can plot up to 200 points by simply placing your xyz values in the available cells. If that's not the example you are referring to post back. Cheers Andy abrusey wrote: Andy, Thanks for the tip ... Fernando's four quadrant scatter diagram is exactly what I'm looking for. Unfortunatly, I don't speak the languange! Can you by any chance explain how to use the add-in? Thanks! "Andy Pope" wrote: Hi, Nothing built in to do 3-d scatters. For work arounds have a look at Fernando Cinquegrani's example, http://www.prodomosua.it/ppage02.html or my own http://www.andypope.info/charts/3drotate.htm Cheers Andy B_S_D wrote: Hello, Does anyone have a solution for creating a 3-d scatter diagram in Excel 2003? TIA -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MS Office 2003 file opening problems | Excel Discussion (Misc queries) | |||
| Filterable online inventory w/out Office 2003 Web Components? | Excel Discussion (Misc queries) | |||
| Do I need Office 2003 to download templates ? Have Office 2000. | Excel Discussion (Misc queries) | |||
| Office 2003 - "autocomplete" in file | open or file | save no longer works | Excel Discussion (Misc queries) | |||
| Office 2003 will not view interactive Worksheet saved as a web pa. | Excel Worksheet Functions | |||
Hybrid Mode
