Excel cannot make 3d scatter charts, only 'Line" charts in which the values
on the 3 axes are categories not true numeric values
Add-ins (SigmaPlot, for example) can be used to get what you want
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"SML" <(E-Mail Removed)> wrote in message
news:763800AF-0009-477E-9E44-(E-Mail Removed)...
>

Excel 2007 3D PivotChart
In case you don't have $749 for SigmaPlot,
here is a 3D spiral with balls.
http://c0444202.cdn.cloudfiles.racks.../12_18_09.xlsm

Hi,

You can use formula to calculate 3d position for plotting in 2d.
http://www.andypope.info/charts/3drotate.htm

Cheers
Andy

SML wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Dear Herbert,

The result you produced is very impressive. I tried to use it in my data, but it was impossible to find the way to depict "balls" instead of "bars". Could you please explain me the way you did it?
Moreover, is there any way in Pivot Tables to put labels in the balls, or at least change colour in them?

Thank you in advance for your response. I am really counting on it!

> On Thursday, December 17, 2009 8:29 PM SML wrote:

>


>> On Friday, December 18, 2009 8:15 AM Bernard Liengme wrote:

>> Excel cannot make 3d scatter charts, only 'Line" charts in which the values
>> on the 3 axes are categories not true numeric values
>> Add-ins (SigmaPlot, for example) can be used to get what you want
>> best wishes
>> --
>> Bernard Liengme
>> http://people.stfx.ca/bliengme
>> Microsoft Excel MVP


>>> On Saturday, December 19, 2009 5:20 PM Herbert Seidenberg wrote:

>>> Excel 2007 3D PivotChart
>>> In case you do not have $749 for SigmaPlot,
>>> here is a 3D spiral with balls.
>>> http://c0444202.cdn.cloudfiles.racks.../12_18_09.xlsm


>>>> On Sunday, December 20, 2009 6:59 AM Andy Pope wrote:

>>>> Hi,
>>>>
>>>> You can use formula to calculate 3d position for plotting in 2d.
>>>> http://www.andypope.info/charts/3drotate.htm
>>>>
>>>> Cheers
>>>> Andy
>>>>
>>>> SML wrote:
>>>>
>>>> --
>>>>
>>>> Andy Pope, Microsoft MVP - Excel
>>>> http://www.andypope.info


>>>> Submitted via EggHeadCafe
>>>> Excel JSON Storing Data
>>>> http://www.eggheadcafe.com/tutorials...ring-data.aspx