Rotating Stock Charts in Excel

[Kev_Astan]

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]

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

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

 

[Kev_Astan]

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

 

[CyberTaz]

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