Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I plot a scatter plot in 3 axies?
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I plot a scatter plot in 3 axies?
You don't - at least, not with any built-in Excel chart options. Probably
because a 3D scatter plot would be pretty tough to read: hard to tell exactly where a point is when projected from a 3D "world" onto a 2D chart. I have found a way to "fake" a 3D scatter plot (but with limitations) if you are interested: Make it a 3D column chart. Turn the data labels on and set it to "show labels" (and with the label alignment make sure they are centered). Then for each data series, set the area and border options for the columns to "off". The columns are now invisible and you see your labels sitting on top of the points - in other words, they act pretty much like the data markers. By using a symbolic font, like Wingdings or Webdings, you can have different "marker" styles. But it is not a very accurate representation, plus there are no options for lines or anything, and (as I said above) it really is hard to visualize the points in 3D. Sorry - best I could do... K Dales "banderson" wrote: |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I plot a scatter plot in 3 axies?
The 3D charting capabilities of Excel are restricted to category axes. The
best you would be able to do is furnish z-values for the evenly spaced X and Y values. -- Regards, Tom Ogilvy "banderson" wrote in message ... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I plot a scatter plot in 3 axies?
There are workarounds, though. A noteworthy one is Andy Pope's 3D
Scatter chart: http://andypope.info/charts/3drotate.htm - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mixing scatter plot with a category plot | Charts and Charting in Excel | |||
XY scatter plot | Charts and Charting in Excel | |||
scatter plot | Excel Worksheet Functions | |||
Scatter Plot | Charts and Charting in Excel | |||
Can I copy x-y scatter plot data direct from one plot to another? | Charts and Charting in Excel |