Area Chart

[Guest]

I would like to know if it is possible to produce an area chart, where
instead of the data being shown in an upwards format (column style ) it is
shown in an acrosswards format (i.e. like an Exel bar chart).

Thanks for your help.

 

[Andy Pope]

Hi,

It's not a built-in style of chart.

You could possible use Jon's code approach, Fill Left example.
http://peltiertech.com/Excel/Charts/VBAdraw.html

Another possibility is to use a bar chart but for each point in the series
you need to plot multiple bars.
Each of the extra bars needs it length calculated taking in to account the
slope between each data point.
The draw back with this approach is the possible jagged appearance and the
formula required to calculate the bars.
Having said that I have created such a chart. I will post it on my site by
the weekend.

Cheers
Andy

 

[Holger Gerths]

Another way is to create an area-chart, then create an excel camera
(copy cells behind the chart, press shift and open excel menu 'Edit' -->
Paste picture link).
Then you open 'Format object' and rotate the camera 90°.

Holger.