Rotating Stock Charts in Excel

[Kev_...@officeformac.com]

Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I have read the threads on rotating Excel charts and realise that Stock charts cannot be rotated there. But I must rotate and put side by side 4 such charts (High-Low-Close). I cannot rotate them in Word or Powerpoint - the rotate function is disabled. I can rotate them and appose them very well in Appleworks but then I lose a lot of definition in the chart and the text. Any solution either in Microsoft or Appleworks
Thanks,
Kev

[Jim Gordon Mac MVP]

Hi Kev,

This isn't the most ideal solution, but it's the best one I can find:

Right-click or control click on the border of the chart\
Choose Save as Picture from the pop-up menu
Choose the PDF format.

Then you can use Insert > Picture > From file to bring the saved PDF
back in. You can rotate PDF pictures, and they don't lose fidelity.

-Jim

--
Jim Gordon
Mac MVP
Co-author of Office 2008 for Mac All-in-One For Dummies
http://tinyurl.com/Office-2008-for-Dummies

[Kev_...@officeformac.com]

Jim,
Thanks, that works a treat. I can flip the charts around and resize them.
My next problem is to get 4 charts to fit onto one sheet , be exactly the same size and align them, feasible but requires a lot of patience and some manual skill but I think I can manage now thanks to you. It would be such a good feature in Excel if we could select several charts of the same size and resize them all simultaneously.
Forever indebted to you,
Kev

[Cybe...@officeformac.com]

Actually, you can. Select one chart then shift-click the others & use the
Formatting Palette's Size, Rotation & Ordering group of features. It doesn't
make any difference if all charts are the same size to begin with or not.

HTH |:>)
Bob Jones
[MVP] Office:Mac

On 12/23/09 4:35 PM, in article 59baf...@webcrossing.JaKIaxP2ac0,