I know that a not long ago, someone else asked about rotating charts,
but the solution offered won't work for me.

I have a 2D area chart which currently runs across the x-axis. I'd like
to run the chart along the y-axis instead. This could be achieved by
either rotating the whole chart object, or producing a chart that Excel
by default doesn't seem to let you.

The other part of my problem is that I'd like the said chart to lie
*underneath* the data in a worksheet. And I need the chart to be
dynamic - I don't want to have to export the chart, make it into a jpg
and then import it as a watermark (unless I can automate the whole
routing in VBA).

To give you an idea of what I'm talking about, have a look at 'this'
(http://www.adambowie.com/weblog/archive/chart.jpg) jpg of another
chart taken from a PDF.

Any help or pointers in the right direction would be greatly
appreciated.


Adam


--
adambowie
------------------------------------------------------------------------
adambowie's Profile: http://www.excelforum.com/member.php...o&userid=28745
View this thread: http://www.excelforum.com/showthread...hreadid=484341